How to copy and paste whole sheets

I've got a file with 75 sheets. Each sheet consists of a fairly elaborate header (logo, other design elements, etc.) and columns of data. I'd like to remove each sheet from this "master" file and copy it to its own file. But when I do this, the formatting is all screwed up- the logo and designs are distorted. I tried to adjust the row width and column height to fix it, but it doesn't come out the same (plus it takes forever). Is there a fast and easy way to copy each sheet onto its own file sheet? Hope this makes sense- thanks so much!

Hey FDibbins,

Thanks for the quick reply and suggestions. I think I may have a problem with version compatibility because when I copy/paste it the numbers are "whited out" on the sheet I'm transferring to. The header shows up smushed but the numbers are gone. What's interesting is that when I first paste or move the old sheet to the new, I can see the numbers under the blue highlighting, but as soon as I click on anything the numbers are gone. I'll try this again when I can use the same version- I think the file is in 2003 and I'm pasting onto 2007.

Thanks again for the help. It's still not working. Screenshot attached- this is what it looks like immediately after pasting. As soon as I click anywhere on the sheet, the white numbers disappear. The header info remains but it changes color. Kind of bizarre!Excel issue.doc