Simple Macro for Merging Excel Files Into One Consolidated File

There are a lot of examples around but first you should read and act on the forum rules.
In your case, read #3.

Thank you - I have corrected this.

Not thoroughly tested. Check all references (Sheets, Ranges etc) and first try on a copy of your folder/workbooks.
All workbooks, including workbook with code, need to be in same folder.

Please Login or Register  to view this content.

Thank you for reviewing this!
Where do I put in the folder path that contains the files to be merged?

Copy all your workbooks (= files) into a temporary (for checking purposes) folder.
Open a new (= empty) workbook (= file), copy the code from post #4 into a regular module in this new workbook and save this workbook into the same folder that your workbooks (= files) are saved.
Now run the code as is.
Let us know what needs to be changed.

Sorry for not answering in a more comprehensive manner. I was in a hurry to do other things but that should not be of your concern.
This line

Please Login or Register  to view this content.

tells the code that all the workbooks are in the same folder. So the code will go through all the workbooks in this folder as long as the workbook name is different from the workbook with code.
As I mentioned previously, just try the code on a temp folder with your workbooks and check the result.

Thank you - this is getting me so much closer.

I'm getting the following message box: We can't update some of the links in your workbook right now followed by a runtime error message of "9" subscript out of range.

I can't change that there are links in the workbooks, but can the code continue past this?

That must be the code from Post #4. Did you try the code from post #8?

Yes, I've tried them both:
Post #4: returns errored links, the error message of updating links appears
Post #8: returns values, the error message of updating links appears, the run time error 9 appears and the file to merge remains open

Thanks!

Maybe try adding the "AskToUpdateLinks" like so.

Please Login or Register  to view this content.

From the code in Post #8:
Change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and let us know what happens

Thanks again for the reply, Jolivanes.

Now, I get the runtime error and the first attempted merged file remains open.

What is the sheet in your master file that you want to copy into called?

The sheet is currently called 'IT Upload'
This is also what the sheets are called from the files to be merged.

These can be changed, if it helps.

If you have no other changes, this is the code you should use.
Both sheets, the one to copy from and the one to copy into are named "IT Upload", without quotation marks.
You copy and paste 8 columns only, from A to H, starting at the second row.
If any of these assumptions are wrong, let us know.

Please Login or Register  to view this content.

Good to hear that you have it all working and nice to let us know that it works for you.
Good luck with it.
Regards