Question: how to copy excel sheet with header?
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. Excel displays the Move or Copy dialog box.