There is no File, Combine command in Excel like in old 1-2-3. Old 1-2-3
needed this because only one file could be opened at a time. But there is
no such limitation in Excel. So, open each workbook and copy from it,
pasting into the consolidation workbook.

--
Jim Rech
Excel MVP