I have a worksheet which is a master list of students.
Column A - First Name
Column B - Last Name
Column C - contains data that will change on a weekly basis.

I have several other worksheets within the same spreadsheet, one for each
subject. Not all students from the master list will be on each of the subject
sheets. Some to Spanish, others do French etc....

I need to make sure that when the data in Column C is changed each week, it
feeds to the other worksheets for the correct students.

I tried paste link from the master list of students to eg the French list,
but if I then re-sort the master list by e.g first name (instead of
lastname), the data pasted to the French list is against the wrong student.

So, the data in eg $c$1 remains the same when pasted to the French sheet,
but then doesn't correspond to the student once I re-sort the master student
list.

I seem to remember doing something like this in the past but am a bit rusty!

Does this make sense?
--
thank you for your help