I have a table1 in Sheet 2 which is feeding multiple pivot tables on Sheet 1 (Executive Summary) and has formulas and a lot of conditional formatting. I need this table1 duplicated and linked in Sheet 3 so I may use the subtotal values from the table based on color filters. I cant do that using table1 in Sheet 2 as changing filters would change the subtotal value. So i'll dedicate Sheet 3 for a particular subtotal after using "color filter" feature of the table and hide the sheet so the filters are not changed.

So basically what I want is that whatever updates I make in Sheet 2 (table1) gets automatically updated in Sheet 3 (table1 duplicate)

I am using Excel 2010.

Any help would be much appreciated.