Create workbooks based on a given template using data in a table

Closed
LinTruthy Posts 2 Registration date Thursday January 12, 2017 Status Member Last seen January 12, 2017 - Jan 12, 2017 at 01:07 AM
an example of data I have on sheet two
Name bio Chem phy lug
John 40 60 50 20
Luke 70 50 30 77
Eric 80 90 89 60
I want to create a workbook per name using a template on sheet one . The name should be in c11, bio score in D17, phy score in d 18, Chem score in d19 ..., each workbook name should correspond to the name in c 11. and the workbooks saved in c :\ reports \ .