?
As the uploaded workbook contains 3 sheets I assume that it is the sheet "Inventory Report" that you are interested in. As this is a pivot table I have not managed to copy both pivot formats and values. So for what it's worth here is a macro for copying the values.
The line
must be changed to the folder name and hard disk where you have the excel files you are interested in.
In order to keep the pivot format one could perhaps copy the "Inventory Report" sheet from each of the 24 excel files and paste those in a "Master file". This would give you a master file with 24 sheets, one from each file.
Alf
Bookmarks