How to copy excel sheet to another workbook with same format and formulas

Hi all,

I have a simple yet complicated question.

I made a very big table/database on the first tab of an excel sheet.

This database is full of formulas etc. and not prety, nor handy to use.

I want to create a second tab in the same file where i can see all the data from the previous tab, but it should also change with the table (the size more importantly) of the table in the first tab.

a simple 'equals to' doesn't work, as data changes constantly in the first tab, the table gets bigger every day.

the table in the second tab should also have some filters, to sort the data retrieved from the first tab.

I tried fiddling around with pivot tables, but the problem is that you can not simply show data, but always the sum of data etc.

It also can't show simple text.

It would be great if you guys found a solution to this problem! I hope everything is clear from my explanation.