I have a need for 3 separate Pivot Tables on the same tab, all three will be based on the same data set on another tab. I want to be able to send this to end users and if they have a need to add/remove one/some Report Filters, the change will cascade to the other two tables. Just the Report Filter though, no need to worry about the Column Labels or values.

For example:
PivT1:
Report Filters
Make
Model
Year
Column Labels
Audio Parts

PivT2:
Report Filters
Make
Model
Year
Column Labels
Tires
Exhaust

PivT3:
Report Filters
Make
Model
Year
Column Labels
Miles

If someone were to add 'Color' to the Report Filters in PivT1 it would also be added to PivT2 & PivT3. At the same time if someone were to remove 'Model' as a Report Filter from PivT1 it would also be removed from PivT2 & PivT3.

Not sure you can accomplish this without writing some VBA. If that is the case, feel free to take a stab at writing up some code. I'm not uncomfortable applying and messing around with it.

Thanks.