Create sheets based on cells and modify formulas within sheets

Hey guys,
I am new to the forum, as you noticed I am a school teacher trying to make my grading process a little easier.
I have attached my basic workbook I would like to use.
Basically, I would like to have a master sheet with the students names on it with their grades, number of wrong answers and have a macro do the following:

create or duplicate the individual student sheet but make it the next person down on the lists name grades.

Continue to repeat until there are no more students

rename sheets with students names

----------------
I think copying the students sheet would be better because the formatting should stay the same. ( I Think)

If you guys could help me out with this one I should be ok figuring out how to change it for different assignments.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I have a macro for taking the data from a database sheet and filling out a template sheet over and over again with the data.

Data Into Template

The macro fills out the template and saves each one as a separate file OR creates a separate sheet, your choice. That last part can be tweaked to do other things, this is mainly to demonstrate a simple way to fill out a form from a row-based database.

=========

That macro has been inserted into your workbook and I've already changed the code to fill in the value in B4 and B6. I made the B1 cell a self-resolving name based on the sheet name.

I've named the base sheet Template. Once you're done designing this, I can show you how to hide the template if you wish.