Discussion on:

Copy an Excel sheet from one workbook to another

Tricky procedure.
There is another similar way and more straightforward.
With both workbooks open, select the sheet to be copied and make a right click over the tab name, from the pop-up menu selec "move or copy sheet", then select the destination workbook (even a new one) and select "Make a copy" box.

It's also worth knowing that more than one sheet can be copied/moved at the same time; just select all sheets to be operated on first and then do the rest as described.

"I don't remember the number of text characters that can go into one cell, but it is a lot more characters than are able to be copied with a simple file copy command. For a While I often gave one of our vendors excel spreadsheets that had "over stuffed" cells only to have them copy the workbook with less than complete data. I tried to show them how to get a complete copy via copying the column and pasting into the new spreadsheet workbook, however, somehow the message didn't make it to the recipient.
oh'well

My suggestion is that to copy a flat file workbook and see if it looks like you have transferred all of the cells contents.

The utility of the flat file excel workbook was that it was easily transferred into an Access database, if desired. "

Above quoted from my comment in a previous discussion "Three things you must do when you inherit an Excel workbook".

For most instances the copy/move instructions are applicable. However, be aware of the limitation that I have attempted to explain. If you don't believe me, run a test for yourself...

You still need both source and target workbooks open.
Right click the tab of the excel document you want to copy/move - it brings up the same move/copy option found in the ribbon mentioned above

Good old Copy and Paste is still pretty good... particularly now that you can right click and choose different ways of Pasting.

Sanjay