Merge multiple workbooks

[sleep]

I have multiple workbooks with all the same named tabs contained within. I want to merge all these into one 'master' spreadsheet. Does anyone know how to do this?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Note: all the workbooks need to be open.

[sleep]

hi,

That great John! Is there anyway it can be done so that I don't have to have all the workbooks open?