To copy a spreadsheet to the next one open the orginal and in the same excel sheet program start a new window.
Make sure you highlight the whole screen ctrl-A, from the original.
Click on the new one and hit Ctrl-V.
I did it just to test it and it worked fine. If it is not copying perhaps you have something turned off or the version is off. I am using Excel 2007.