I am building massive pivot reports - many pivots on many sheets of a work
book.

Is there a way to select a page field value in a pivot ( or other fields as
well) and have all other pivots on the sheet, other sheets, and the entire
workbook have there page filed set to this same value.

This would allow me to deploy some fantastic tools to people.

I am speaking of slect the customer(one fo my fields) in a single pivot -
designated as the master pivot if thats easier - then have automated switch
to that cusotmer in all other page fields.

Thanks for the time