Moving data from source workbook into pre-formatted workbook with one click (multiple tabs & pivots)

 

Hi,

 

I have to create the same workbook 30/40 times a week.

 

I have a blank template set up with formatting and pivot tables and currently, I have to copy and paste  from individual "source workbooks" into each tab, refresh pivot tables and then SAVE AS each individual file. It can take 3-4 hours a week.

 

I have tried using a RECORD MACRO but it doesn't like the pivot tables and stops running.

 

The Source Workbook is the file I get 30/40 different versions of a week and the Formatted Workbook is the document I have to copy, paste and edit the data into.

 

Can anyone help?