I have a workbook that contains three worksheets:
a data table
a pivot table report of the data table (with the "Organization" field
located in the pivot table's Page field)
a switchboard with a drop-down box that contains the organizations listed in
the data table and pivot table

I need some code that selects the organization in the Organization page
field of the pivot table that corresponds to the organization selected from
the drop down. So, if one selects, say, "New York" from the drop-down box,
"New York" is selected from the pivot table Page field ("Organization") and
the pivot table refreshes to show New York-only data.

Thanks,
EU