So.. I've got a data sheet, and a "report" sheet. On the report sheet there are about 18 different pivot tables to compile a 3 page report. I want to be able to switch the PAGE field of the pivot tables (all of them) at the same time, to the same value. For example. Report for "Owned" sales would switch all the page fields to "Owned", or for "Consigned" it would switch all of them to "Consigned" automatically. Do I have to use the developer drop down buttons? What do I need to do. I consider myself moderate to advanced in excel but I know very little VB.