I have four pivot tables that I have created because they are from different
source data. However, I want them to all use the same criteria - for
example, if the first table is all "men" data, I want the other three tables
to also be "men" data. Is there a formula that I can use to link the drop
down box in the other three tables to the first table, so that when I select
something in the first table the other three change? Help!!!