Excel Merge Documents -

You now have a master sheet. Next month, drop new files into that folder, right-click the results table, and select Refresh . All new data appears instantly.

In a new Excel workbook, go to the tab > Get Data > From File > From Folder . Select your folder and click Combine & Load . Select the sheet or table name common to all files. 2. Merging for Reports (Mail Merge) excel merge documents

If you want to learn more about merging documents in Excel, here are some additional resources: You now have a master sheet

There are several methods for merging documents in Excel, including: drop new files into that folder