Looking for method to consolidate sheets that are open.

[auto.pilot]

I am familiar with and use a macro to combine data from closed workbooks, but I have the opposite situation now (XL07). From a database, 91 Excel spreadsheets are opened. Call them Temp Sheets. Each has a unique name like Output001, Output002, etc. I'd like to combine these into one spreadsheet without saving them. The order is not important, just want to copy/paste columns A:G from each of the 91 spreadsheets and stack all the data in Column A:G on a separate sheet. Can this be done?

Thanks in advance for any and all suggestions.

jim