Get the code here https://www.bluepecantraining.com/excel-vba-to-combine-all-workbooks-in-a-folder-into-a-master-workbook/

This video details the VBA code needed to combine/transfer/consolidate all workbooks within a specified folder into a single master workbook.

The VBA code loops through each Workbook in the specified folder:

1) Opens the workbook
2) Copies/ transfers the first worksheet to the master workbook
3) Closes the workbook
4) Names the new sheet in the master workbook - borrowing the name from the source filename

Once this has been achieved the worksheets in the master workbook are sorted by date (month) order.

VBA functions included in the code are:
1) DIR to retrieve the filename of the files within the specified folder
2)MONTHNAME is used to sort the worksheet names in the master workbook.
------------------------