How to expand a macro to multiple spreadsheets and pivot tables

Hi all-
I have multiple pivot tables in a spreadsheet, and I'd like them all to filter by changing one cell. I found this code to do this for one pivot table, but I am BRAND new to VBA (I know SQL, SAS which is not helpful).

Can anyone help me expand this code for more than one worksheet and pivot table?

Thank you!

Please Login or Register  to view this content.