Thread: Merge identically laid out workbooks into one workbook (multiple identical sheets)

Ok, I have searched all morning trying to find this. Sorry if it's already out there.

I have a workbook that is a template that customers fill out everyday. There are multiple worksheets in this workbook.

I need to combine every workbook into one big workbook with everybody's requests from each tab.

The entered information starts in row 3 on every sheet. (First 2 rows are headers).

So each individual workbook will have the EXACT same sheets/columns. I normally manually copy and paste, however the load is getting to large to process this way.

I've attached the template that customers send to me with their information filled out.

Thanks in advance!