Merging an Extensive Amount of Excel Files

Hello there,

My question is described in the title, I want to merge an extensive amount of excel files (close to 100), into one clean spreadsheet. I'll describe the data.

Each file is only one sheet, with the same variables and structure, but of different sizes.

Product ID Amount

10034152 25
10023694 42

That's just a simple example of what I am looking at. Then I was hoping to put each of those sheets together, and organize by product ID to get the totals.

Is there any Excel add-on that could help me or some external software that people know about?

I appreciate the help.

Two options spring to mind.
1) A quick forum search for the term "Consolidate workbooks" will no doubt result in some VBA code you can amend to suit your needs.
2) You could use Power Query. It's designed to do this sort of thing and is a free addin to Excel. Plenty of info on here for that too.

Beth