Hi there. I'm looking for solutions to my automation problem. The Facts I have a master workbook broken into 12 tabs (per month). I have a template workbook that records information and is saved to a different file name each time it is used. I want the new file (that was the template) to automatically dump data into the master workbook). Hundreds of these new files will be created each month, and I want them to automatically dump. I want this as automated as possible. Any suggestions on how I may make this happen?

Automating a master spreadsheet

Hi there. I'm looking for solutions to my automation problem.

The Facts

I have a master workbook broken into 12 tabs (per month).
I have a template workbook that records information and is saved to a different file name each time it is used.
I want the new file (that was the template) to automatically dump data into the master workbook).
Hundreds of these new files will be created each month, and I want them to automatically dump.
I want this as automated as possible.

Any suggestions on how I may make this happen?