Macro to copy template and auto fill from master

[mandar86]

Hi team excel,

I have created a mark book as seen attached. However, I want to create a macro button (which will be visible on the markbook worksheet) that when pressed will do the following:
1) Copy a template profile (as seen in profile worksheet) to create a new worksheet
2) Each worksheet will be named based on the students name
3) Then be populated by the data in the markbook worksheet for each corresponding student.
Eg: If I had 1 student name Bill Smith who received an A for semester 1 (in the overall column), then a B for semester 1 and 2 (in the other overall column), when I press the macro a new worksheet will be made called 'Bill Smith' and the two results will be auto filled in the newly created worksheet next to 'result'
Then rinse and repeat for x number of students.
Also, I want it so that I can press the macro multiple times (as new data comes in or changes, it refreshes the data in the profiles) without creating duplicates/errors.

The attached markbook is not complete, but if someone can show me how to just populate the 'result' for semester 1, I'm sure I can modify the macro to copy all the other values I want the profile to copy.

I have read this about 4 times myself, I hope it makes sense to the excelers reading this.

Thanks in advance!