Hi bighop and welcome to the forum,

I would not use separate workbooks but a single workbook with a sheet of all student names. Then, if needed a sheet for each teacher.

I'd even consider using a single sheet for student names to use as a lookup list and another single sheet for all the rest of the data. Instead of having a separate sheet for each teacher, you could have a column with teacher's names.

Pivot Tables or filtering would then allow you to do your reports and collect the information.

Using different workbooks and even different worksheets reduces the power Excel has with tables and formulas.