Create a MS query which reads data from your table, and stores result on another sheet.

For MS query from excel:
a) You create a nondynamic named range (the one which refers to range like Sheet1!$A$1:$Z$1000), which includes your table with header row. When the number of rows may change in future, be sure that defined range has enough empty rows at bottom. Ater that, save the workbook and then create a query. As driver select one for MS Excel files, as datasource, select your workbook, and then the named range you created.
b) You create MS query as above, but without defining named range. After selecting your workbook, switch to System Tables tab (or something like that - I haven't Office at home currently so I have to count on my memory here), and select the worksheet with your table.

Btw., the MS query from excel files is somewhat buggy. Often it gives a message, that some parameters are missing - especially after you edit it. Sometimes the query will work after you close the query designer window, sometimes not. When not, then try with new one.