Can anyone help please with the following:
I have a very large workbook with pupils names and abilities listed on 10
tabs all listed alphabetically and identical. Alongside this data I also have
individual numerical and written data for each pupil under their different
subjects.
i.e. Lucy Smith, Female, Able + Talented, Class 11A, Teacher N Jones, KS3-C,
Current Grade D, etc then Subject data for each pupil, i.e English, Maths etc

I have tried to link the data to match only the first bit, i.e the generic
name and abilities area onto numerous tabs, however it eiher links the data
fine but adds in '0' into blank boxes, which have to remain blank, and when I
choose 'skip blanks' it simply loses all of the formatting!
The other issue is that if I delete a pupils entire row from the first
sheet, will it know to delete the same 'row' from the other tabs and delete
only the same 'row'?
If i link the entire sheet to the other tabs wont it mean that it copies the
whole data? I only need it to copy certain cells info but somehow get the
sheet to know that if i insert a row or delete a row then it has to do the
same in the other tabs for the same pupil only?
Help please?