Copy a range of cells in multiple sheets

Hi there,

I am trying to automatize a series of action to facilitate the procedure that I use to mark students` essay.
Here what I would like to do:

I have a "StudentList" sheet containing students ID, Student Names and Marks and a "MarkingCriteria" sheet containing student details, marker details and assessment criteria.

After entering the student list I would like to be able to create a MarkingSheet for each student, assign the sheet the name of student and copy the contents of the MarkingCriteria. I need that the student`s detail (name) in the Marking Criteria match the Sheet name`. Further I need that the Final mark calculated for each student return the "StudentList" in the column "Mark".

The only thing that I managed to do as a novice VBA user, was to create a CommandBotton that create one sheet for each student. However I don know how to insert the MarkingCriteria in this sheets...


I enclosed my file...if someone wish to help me.

Thanks

G-Star