help with invalid subscript

Someone helped me create this a few years ago, I just added data and now when I try to "add new student" it says the subscript is out of range, can anyone help me fix? I'd also like to upgrade so that when the data is altered in the "Students at a Glance" Tab it automatically updates the top information on the individual tabs.Copy ESOL.xlsm

You do not have a sheet name(Glance) but you have GLANCE-ADMIN
Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

subscript is out of range because of this line:

Please Login or Register  to view this content.

You don't have a worksheet named that. I'm guessing you recently renamed a tab? Anyway, either change the tab name back to Glance or modify the code so that the name of a worksheet you have in this workbook is on that line.

You'll have to explain the upgrade you want in a little more detail, I'm not sure what your asking. Can you provide an example?

Copy ESOL.xlsm

Thank you so much! I was able to fix the reference for glance, but now when I click the "Add students" button, it stops after 48and says "error 400". Any suggestions? I'm so grateful for your help!

I do not know which code is addbutton. You have a link to external sheet. You need to disable the link and run the code.

Thank you, is there any trick to finding out where the external link is? There shouldn't be one, so I'm not sure where to being looking.

Yes, when click yes to the link, it shows you the source of the link. You have few options once yes to the link.
I can not remember where exactly, but there is a setting on your Excel's options( I think it is advance) where you can disable all links.
In your sheet, you get another error of circular reference. I think that might be the link.

Copy ESOL.xlsm

Okay, I took out the error references, there were in the conditional formatting. However, I still have the same problem When I click the gray button at the bottom (cells 76-78), I get an error and not all the student tabs are created.