Question: how to copy a header from one excel sheet to another?
Answer: Open the target workbook; the one to which you want the headers and footers copied.
Open the workbook that is the source of your header and footer, and make sure the desired worksheet is displayed.
Choose Move or Copy Sheet from the Edit menu.