2 problems perhaps:
1. So you don't have the UNIQUE and FILTER worksheet functions available to you? (You'll get #Name? in cell F2 of the Append1 sheet)
2. Select say range B3:D8 of the Append1 sheet and press delete on the keyboard, then if you right-click in the same table and choose Refresh, does the data come back?