I'm trying to make a macro to automate a tedious process of creating product
detail forms from a summary page.

Sheet 1 is the summary page containing data in columns A-N.The number of
rows is unlimited.

Sheet 2 is a template that would be filled in with the data from Sheet 1,
but each row in Sheet 1 would get its own individual worksheet - if I were
doing this manually, I would make as many copies of Sheet 2 as I have rows in
Sheet 1, and fill in certain cells on those sheets with the data in columns
A-N on Sheet 1. Also, the name of the worksheet would be the value in column
A.

For example, if Sheet 1 contains 10 rows of products, I would make 10 copies
of sheet 2 - the first copy would contain the data in row 1, the second copy
would contain the data in row 2, etc.

Is there a way to write a macro to automate this process?