I have a spreadsheet with several worksheets. Each worksheet has a pivot table on it.

I want to write a macro to perform the same formatting tasks on each pivot table.

I want to be able to use the macro in any workbook containing pivot tables regardless of how many worksheets there are or what the pivot tables are called.

Please help!!!!!!!!!!