Create new sheet for each row and include header

[Sabosis]

Hello-

I have a worksheet with the title rows in rows 1-3. Below that are the
rows of indivual statistics for employees, usually 10 rows but could
be anywhere between 8-12. I was looking to add code that would create
a new sheet for each employee, have the title rows on each new page,
then in row four, the stats each employee on their page. Also, the
employees name is in column A on the main worksheet (A4, A5, A6,etc).
When the new page is created, the employees name would be in A4 below
the title rows. Can the value of A4 be used as the sheetname for each
sheet created?

Thanks in advance for any help provided....

 

[Don Guillett]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.