Automatically update tabs based on a cell reference

Hi, I'm new to using VBA but with some programming experience.
I'm a teacher, I have created a separate worksheet for each student in a workbook. I want to be able to change the tab names automatically to reflect student names held as a separate list in another worksheet.

I have found this code to change tab names to reflect the content of a cell reference but i have to update each worksheet individually. Is there any way of getting this to run automatically when I open the spreadsheet or better still, dynamically when I change the class list?

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Sh.Name = Range("$A$1")
End Sub

(A1 references the class list)

Many thanks for your help,
Andy

Hi Sixthsense, thank you for replying so quickly - really appreciated!
I have set up a sheet for each student named STUDENT 1, STUDENT 2 etc up to 30. Each sheet has a reference in A1 to the student's name held in a sheet named CLASSLIST. It all works well if I go into each STUDENT sheet and tick the formula in A1 - it's just a bit inconvenient!
I could try a macro, but I was wondering if it is possible to update the tab name dynamically - i.e. as soon as I change a student's name in CLASSLIST.
Hope this helps!
Thanks again,
Andy

Here it is . . . Cant see GO ADVANCED hope this is OK, Thanks