Pivot Tables/Charts and common filter
 

I have a set of data which is used to generate multiple pivots charts. Each
set of pivot charts also runs from different data worksheets. However, for
each chart the report filters need to remain the same.

I was wondering if you can link the report filters together so that when you
make a change to one filter all the filters change to the same selection. Is
this possible? Thank you.

Pivot Tables/Charts and common filter
 

Is an Excel 2007 VBA solution acceptable?
If yes, provide sample data.