VBA - Load multiple workbooks(sheet2) into multiple a workbook with templates.add

Greeting all,

I am checking if anyone has the below scenario as I have.

I am looking at sheet 2 of the many workbooks i have (similar format-3 files attached). I would like VBA to help me read from a folder and extract data from these sheet 2 and load into a master workbook (summary format attached).

The 2nd worksheet in the master workbook(Summary Format) will have an empty template format (ignore 1st sheet - summary of behind data for my calculations purposes). So the code will read number of workbooks in the folder, it will copy the template of Summary Format (sheet 2 of Summary Format) and add sheets(template) into the master workbook and start loading data from the many worksheets(sheet 2) into these templates.

One sheet 2 into One template(worksheet in Summary Format).

Any one has links or sets of code that do the similar?

Thanks in advance!