Sub makeshts()
For i = 1 To 21
Sheets("Template").Copy After:=Sheets(i)
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"LC" wrote in message
...
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.