combining excel sheets from different excels workbooks

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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.


Site Timeline