Get the code: https://www.bluepecantraining.com/excel-vba-combine-multiple-workbooks-into-one/

This video demonstrates how to combine worksheets across mutliple workbooks in the same folder into a new workbook. So our folder has four workbooks, one for each quarter. Each workbook has three worksheets (one for each month). Our new workbook will end up with twelve sheets.
------------------------