Changing the same filter on multiple pivots

I have a file that contains over 10 different pivot tables and charts. They are all linked to the same raw data and they all have the same report filters that can be applied to the data. One of the report filters is the country (there are 12 different countries). Is there a way to change all of the pivot filters at the same time? Right now you have to go to each individual pivot, select the report filter and change it to the desired country. My only thought is recording a macro of changing the filter for each country.

anyone know if there is a way to change all pivot report filters at once?

thanks

Writing a macro to change all of the filters is actually pretty easy. I recorded one macro to change all the countries, then copied the macro over again and used find replace to make a new macro for each country. Now the issue is that people who are very unfamiliar with excel are going to use this sheet. is there a way to move the macro commands to the sheet? So that instead of going to the view macro command in the ribbon can I have the command to run a macro in a cell in the sheet?

Wow, I didn't know about slicers. That's awesome!