One method is to right click on the Tab of the worksheet you want to copy,
then select Move or Copy. When the Move or Copy box opens, check the "Create
a Copy" box. You now have a new tab (that you should probably rename) and
the worksheet has the same headers, footers, print area and data as the
copied tab. You can easily put 20 tabs in a workbook. Good luck.

"LC" wrote:

How do i copy data from one sheet to another, to include the footer and
header.
I created a log for work. I need 20 of them to be able to fit everyones name
on it. I would like to have 20 separate sheets.

Am I able to have 20 sheets in excel?

Thank you.