create a dynamic copy of a table on another sheet in the same book?

[merlin777]

I have a large table of data which changes size (increase/decrease rows) every day.

I want to put a copy of this table which reflects changes in the original table on another sheet so I can add more formulas, subtotals and filters etc.

Is there a way to do this? I tried a pivot table but it doesn't allow complex formulas to be added.