Using Excel 2002

When doing a copy/paste of a worksheet into another Excel file, or
into another tab within an Excel file, how do we make the header and
footer stay with the worksheet so that it appears after the worksheet
has been pasted?

Thanks,