Gathering data from multiple excel files into a consolidated file- Possible MACRO??

[AFIOF719]

Trying to learn the basics of how to pull data, from the same formatted excel spreadsheets, combined into one consolidated spreadsheet. I created a few examples below of what I am trying to do. Eventually, I want to be gathering data from over 200 spreadsheets at one time. I believe that a MACRO is needed to do such a thing. I am not sure of the complexity of the MACRO, so hopefully I will be able to mimic whatever needs to be done in my actual file. I have almost ZERO experience with MACROS, so if this is way above entry level MACRO, then please let me know.

Below I have 3 spreadsheets, and I want to collect the data from those 3 spreadsheets into the consolidated spreadsheet.

Please HELP!

[Tinbendr]

Assumptions
That all the data files are in their own directory. You will have to change path in code.


While all your examples only show one entry, the code is dynamic in that it will read all entries under Machine/Time/Location. So if the customer works out on three different machines on the same day, it will import all entries.

F8 will show a list of macros to run.

Once you're pulled everything in, I recommend you delete the files, or move them to a new folder.

[AFIOF719]

Thank you for your reply. I do not seem to understand to to get the data into the consolidated. My intention was to have a folder every week with different files. So that, I can use a macro to pull from whichever folder I chose. I seen it before but have no idea how to do it.

So basically each week I want to:
Open the blank 'Consolidation of Data' document
run a Macro that will ask me which folder on my computer I want to pull data from
chose the appropiate weeks folder
then the data will be collected in the 'Consolidation of Data' file with all the excel files information that were in that folder

I know I may be asking a lot. I am not very good at macros/vba so any help would be much appreciated.

Thanks in advance for any help I can get.

[Tinbendr]

run a Macro that will ask me which folder on my compute

Yeah, but you didn't ask for that in your original request.

[AFIOF719]

Great! Thank you, exactly what I needed.