combining excel sheets from different excels workbooks

[Vumani Dlamini]

I have several excel workbooks each with 4 sheets named page1,
page2,.., page5. I would like to create 5 new workbooks where each
page is combined into one excel workbook. That is all the "page1"
sheets are combined into one workbook, etc.

I just can't figure out how to do this.

Thanks a lot.

Vumani