VBA code to merge multiple excel workbook to one

Hi
I reviewed the code.
As my understanding it will create a summery workbook which copy sheets from multiple source workbook( excel files )

Actually, I am looking for VBA code to merge all sheets from different excel workbook (excel files) to one summery sheet.

For example: I have 4 source excel workbook( test01.xls, test02.xls, test03.xls and test04.xls.
each excel file has uniqe sheet name. I want to copy all data of sheet named "A-I" from test01.xls, all data of sheet named "J-O" from test02.xls, all data of sheet named "P-T" of test03.xls and all data of sheet named "U-Z" to one sheet named "summery" of target workbook test05.xls.
Therefore, sheet named 'summery' of target excel file test05.xls contain a single sheet of data from all source sheets above.

It would great if you provide me VBA code for that purposes.

Thanks

I am still waiting for response. I would request to review my previous comment what exactly I am looking for.

Thanks

If anybody advise me with sample VBA code to merge different excel file(1st sheet per file) to one sheet in a defferent excel file.
Thanks in advance for your prompt response.

Waiting for sample VBA code for a faster way to do this.

Thanks