Retrieving the highest value in a series of the same cells but on different sheets

[Tronulas]

Hi guys, wondering if you can help! Im not that clever to work it out.

I've set up a fantasy football (soccer) spreadsheet last year, and works great (thanks to people on here). But i've just come across a problem.

I've just realised that this year, we have a prize for the, highest scoring individual player game week. Does anyone have any ideas, how i can go about this, with out individually writing an equation per person. I have 100+ participants this year and will be a long day of imputting them in.

My only idea is for each week find out the largest score, and if it is larger than the previous that will be the new formula to be tested against. But there must be an easier way. Any one out there help.

Many thanks for your help in advanced

Gaz Hughes