Ranking across multiple excel sheets

[Novicesportsperformer]

Hi all,

I was wondering if you could help.

I have sixteen worksheets all player names (ie John, David, Joanna, Laura)

each sheet uses the same template of tests in column A and the Score in column B.
I would like to rank each players score for that specific test in column C .

Ie

1600m Test (A2), Score (B2) Rank of the squad (C2)

Is it possible to compare all the B2 scores on each sheet and give a player rank on C2 of each sheet?

Thanks and looking forward to hearing from you