Roberta,

If you've copied the entire sheet (Right-click its tab - Move or Copy),
instead of copy/pasting the cells within the sheet, all the Page Setup
stuff, including the custom header, should come with it.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Roberta" wrote in message
...
I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I
have no problem of copiing and pasting the data into one workbook but is
there a way to copy the customer header/footer into the workbook for each
sheet?