When I copy a spreadsheet in a workbook to another spreadsheet in the same
workbook, my formatting in terms of orientation (landscape) and my
header/footers are not copied to the new worksheet. Is there a way to do a
template so that anytime I copy an existing worksheet, that the formatting
will be pasted onto the new worksheet?