What I am trying to accomplish using a VB macro/coding is the following. I have two spreadsheets, the first is a "Template" spreadsheet that is filled out and contains a worksheet that collects raw data. The second spreadsheet acts as a "Consolidation Script" which pulls the raw data from a worskheet in the "Template" spreadsheet.
There are multiple "Template" spreadsheets each month that get saved with distinct filenames and are all located in the same folder as the "Consolidation Script" spreadsheet. I want to use the "Consolidation Script" spreadsheet to pull all of the raw data together from the multiple "Template" spreadsheets into a single worksheet in the "Consolidation Script" spreadsheet.
I've attached a screenshot to display what the "Template" spreadsheet raw data worksheet looks like. Thanks in advance for any assistance.