Search for a name and return the value of a given cell

Good morning,

I am trying to search a sheet for a given name and return the total point for that marking period. The main problem i am having is that the names aren't in the same cell on each sheet. It is a list of students and each sheet represents a marking period.

I have attached the file any and all help would be greatly appreciated.

Los