change pivot table filter automatically and automatically print after each change

[gb123]

hi,

I have a spreadsheet with several pivot tables. I already have it so that if I change the filter of 1 pivot table, I change them all. My objective is to automate the following steps from beginning to end.

1 - Change pivot table filter to the first SKU on the list
2 - Once, formulas are updated, print worksheet
3 - Go to next SKU down in the filter and repeat step 2
4 - Continue until last SKU in the pivot table filter reached - end

Thanks