Hi Guys,

I have a workbook with multiple sheets. On those sheets, there are multiple pivottables.

I need a macro that search for all the pivottables (we don't know each pivottable's name) on all sheets and filter them by a cell valule, for example in Sheet(1) A1.

The purpose of this is to be sure that all pivottables are filtered by the same value. Then I can retrieve data from those.

Thanks!