As someone who has been working extensively with Google Sheets and its related functionalities, I am certain that I am the right person for this task. In fact, building clear user interfaces and creating interactive scripts for Google Sheets has been one of my specialties.
My expertise in Google Apps Script combined with a deep understanding of data linking across sheets can be the key in hiding your main sheet and providing a secure way to allow pupils only to see their respective rows. Additionally, a proficiency in formulas and VBA will also enable me to develop a system on 'My Work' sheet that stays updated with the changes you make on the main sheet.
Moreover, having worked on tons of projects over the years, project management is something I'm well-versed with - commendable time management skill and strict adherence to deadlines being the hallmark of my work ethic. Rest assured, if you entrust this task to me, not only will I deliver a solution that is easy for *you* to understand and replicate but also ensure that it can be applied effectively to your other gradebooks. Let's make this happen together!