Hello,
I have a spreadsheet containing over 400 rows of data and 7 columns. The number of rows change from each week. I need to create a macro that can create a new sheet for each row. Also, on the new sheets data would begin on row 13, and new sheet would be named whatever the ID number is. See below for example.

Example sheet 1
ID Name Nickname Position Department Sub-department Q1 2015 Score
210033 James Franco Jimmy Cost Supervisor Finance Accounting 97
214044 Bill Gates Billy Income Auditor Finance Accounting 67

So the new sheet would be:
Example sheet2 named 210033
ID Name Nickname Position Department Sub-department Q1 2015 Score
210033 James Franco Jimmy Cost Supervisor Finance Accounting 97

Example sheet3 named 214044
ID Name Nickname Position Department Sub-department Q1 2015 Score
214044 Bill Gates Billy Income Auditor Finance Accounting 67

Can anyone help me with this?

Thank you!