Macro to open files in a set folder and copy the data from a specific tab to a master

[saraapple]

I am trying to take data from individual files in a folder and copy them to a master document.
This is because my data has been recorded in a new work book for each day then saved to a folder by month - I need the data all in one sheet so I can study 12 months worth of files!
I know there has to be a better way than opening them one by one - but my attempts to do this cant get me past locating the folder where the individual workbooks are, and the requirement to open different workbook names.
Any help would be greatly appreciated, finding a way to do this could potentially save me days/weeks of work!

 

[Zot]

There are many sites and even YouTube videos on this. I think this is the best for your task.

Loop Through All Excel Files In A Given Folder

This VBA macro will let you select a folder path and loop through each of the Excel files in the folder. The macro code opens each Excel file, performs a task, saves the file, and then closes the workbook.

www.thespreadsheetguru.com

 

[saraapple]

Thank you so much for the recommendation the article covers exactly what I need, in fact its better than what I wanted as it can be adapted for so many different things.
Huge thanks for taking the time to point me in the right direction

 

[Zot]

Thank you so much for the recommendation the article covers exactly what I need, in fact its better than what I wanted as it can be adapted for so many different things.
Huge thanks for taking the time to point me in the right direction

Glad it helps and I did not have to invent new tire ?