I'd like to know if its possible to add a control button or drop down list to a cell, and based on your selection, it will update multiple pivot tables.

I am extract data into a file that has the balances of certain accounts by product and region, by month. I want the user to select May, for example, and have the pivot tables update to include May 2014, 2013 and 2012 data.. instead of them going into each pivot and selecting May in the Field List.

Is this possible?

Thanks