run macro then print the results as pdf file changing the name eac
 

I have a workbook with multiple pivot tables/charts, I have several macros
changing the field data in these pivot tables, I want to print after each
macro is run. Each print will be to a pdf file and the name (and possibly
location) of the printed file will change.