This looks really cool and impressive. Every time the user hit the Refresh
Macro it actually updates 4 pivot charts on the €œUser€� tab.

Here is part 2 of my request. Management wanted static reports, preferably
in ppt. How can I create a Macro where it pre-set the 4 parameters
(prog_user, origin_user, dest_region_user, lsp_user) to certain values,
updates the charts and copy (as pic) to ppt? Copy to another workbook with
multiple sheets is also fine. I can do a one-time manual link to ppt and then
break link.

Any suggestions?