Excel consolidation

[Guest]

I have several spreadsheets that I want to combine into one new workbook with
each old spreadsheet as individual worksheet tabs. I am tired of toggling
back and forth between mulitple opened files. Help.

 

[Pete_UK]

Open the first file and adjust the file window so you have some grey
area around it in the Excel window. Then open the second file and
adjust its window so that you can see a part of the first file's
window underneath. (I would normally arrange the first window to
occupy the left hand half of the screen and the second window to
occupy the top half of the screen).

Then drag the worksheet tab from the second window to the first - this
will move the sheet into the first file (retaining the sheet name -
make sure it is not the same as the sheet already in the first file)
and the second window will close as there is no sheet in it (assuming
you only have one sheet per file - if not, then close the second
window and click No when asked if you want to save the file).

You can then repeat this for subsequent files, and when all is done
you can save the first file (maybe with a different name - use File |
Save As) which will have all your sheets in there.

Hope this helps.

Pete