pull specific sheets from one file to another file

[jammoca]

I have a workbook called 'Teacher A'. In this workbook, I have a sheet called 'Student List'.
In cells C10:C40 I have a list of student names.

I also have a workbook called 'Master'. In this workbook, I have about 400 worksheets, each with identical format to eachother but obviously with that student's own scores for exams and so on. Each sheet is called whatever the student is called ... example 'Student 1' or 'Student 2' all the way up to 'Student 400'.

I'd like to have a button in the 'Student List' sheet of the 'Teacher A' workbook, that when pressed will take a copy of each of the Worksheets (from the Master workbook) that bears the same name as the names in the list found in C10:C40.

eg: if the C10:C40 list contains the following names ...

Student 32
Student 41
Student 45
Student 67
Student 112
Student 118
Student 239

Then the worksheets in the Master workbook that have those same names should be copied and appear in the 'Teacher A' workbook.

Is this possible ?

Would the sheets in the Master workbook have to be unprotected for the transfer to work or can I have them password protected and it still work ?

All the best,

Chris

 

[jammoca]

.

 

[jammoca]

.