VBA COPY and PASTE BODY RANGES By MONTH(last column)

Hi All,

Please see the attached dummy file. I have a "Pivot table" Sheet tab and a "destination" sheet tab. I want to copy paste special value the body ranges from each pivot table according to the months to choose the last column from the "pivot table" sheet tab and copy "destination" sheet tab. Also, since this is a monthly data, every month a new month will be added, so in the code need all pivot tables to be refreshed as well when new data comes in with a command button.

It looks like the pivot tables give you the breakdown you are looking for. What is your request?

Hi Maniacb,

Thank you for replying back! Cant appreciate enough. Please see the attached file. So basically,
I want to copy the "pivottable" sheet tab body ranges in pivot table to the "destination" tab. I want it to automatically copy and paste it
special value with months being added every month so to chosse the last column. The format on the destination tab will be exactly the same as
my real data and pivot tables as well. Also want it refresh each time.