Excel VBA taking data from master, create sheets, transfer data

Hello,

I am working on an excel project for a college. When recording marks they have a master worksheet with the entire roster of students with grades broken down into projects, tests, exams, and other graded tasks. (so a table with student names in column A, project one grades in column B, etc.)

From there, they create an individual sheet for each student with their own grades broken down in the same categories.

I would like to have a button on the main roster sheet that would copy a sheet template for the individual student pages, create a new sheet with that copy for each student, then input all the data from the main roster into each appropriate sheet.

Hoping there is some way to make this work! Thanks a lot.