$$Excel-Macros$$ Help with macro code: copy and rename template from a list

In search of a solution using a macro I would like to copy the 'active sheet' and rename each sheet created from a list on a hidden sheet in the file. The list changes based on which 'class' is selected from the list on the active sheet. I have a sheet1 "student" = activesheet s

$$Excel-Macros$$ Help with macro code: copy and rename template from a list

In search of a solution using a macro I would like to copy the 'active sheet' and rename each sheet created from a list on a hidden sheet in the file. The list changes based on which 'class' is selected from the list on the active sheet. I have a sheet1 "student" = activesheet s