This place seems great to find answers to complex problems. I've been searching for weeks all over the place for a solution to my problem but have found no luck. Excel 2010 slicer (horizontal and vertical) partially solved my problem, but given I and almost all users in my company use excel 2007, I can't do anything with slicers. Here goes:

Application:
MS Excel 2007

Background:
1. Three raw data worksheets (huge)
2. Over 10 pivot tables (one per worksheet) pointing to either of the three raw data worksheets
3. Over 10 pivot charts, created from each of the 10 pivot tables

Requirement:
1. In a NEW worksheet, have three pull down menues (for Report, Row and Column labels) that enable the user to select a filter that replicates across only those pivot tables and charts that are linked to the same RAWDATA.

2. Given there are THREE raw data files, it would be ok to have a THREE sets of pull down menues that replicate across the three differently sourced pivots and pivot charts.

Example Column Headings for Raw Data worksheets and Related Pivot table/chart structure
Raw Data 1:
Country | Service Order # | Month | Week | Time to Complete | Order Type
Report Filter
Country
Column Label
Month
Week
Row Label
Order Type
Values
Count of SO#

Raw Data 2:
Country | Order Status | SLA | Delta | Service Order # | Month | Week| Order Type
Report Filter
Country
Column Label
Month
Week
Row Label
Order Status
Values
Count of SO#

Raw Data 3:
Country | Leg Time | Leg SLA | Leg Owner | Leg Delta | | Service Order # | Month | Week
| Order Type
Report Filter
Country
Column Label
Month
Week
Row Label
Leg Owner
Values
Count of SO#