Help for auto returning a value between worksheets...confused teacher

Hello Kelly,

Try this.  I took the liberty of feeding the names from sheet one to all of the other sheets, so you only have to add the names once.  I did this because it directly references back to the cells on the other sheets, it doesn't care if the name to the left is the same.  It doesn't allow for adding someone mid-year.  You would just add them to the first empty slot on the first sheet, and track from there.  It's fairly simple, but potentially easy to break as well.  Each sheet is protected, with the cells with formulas locked, but there is no password, so you can just go to the Review tab, and click unprotect sheet.  Let me know if it will work for you.