Sorry I don't think I have explained myself very well.

I am looking for a way that all teachers can enter their homework title into D1 depending on the class they teach then enter their marks for that particular title and class into D5:D118.

Or a dropdown where they choose just their class ( class G2 for example) and only data for their class appears and they can enter the homework title and marks etc