Hello,

I am running into a problem where I would like to make a summary page illustrating the person with the highest value in column a. Each tab has the associated teacher and the student's name and test score. For example:

Column A Column B

Student Score
Joe 81
Matt 96
Lindsey 85
Amy 65
Courtney 60
Santiago 85



Is there a way to be able to incorporate an index, match(max) formula? I tried the following.
=INDEX('Amy Stewart:Jennifer Brown'!B3:B8,MATCH(MAX(('Amy Stewart:Jennifer Brown'!B3:B8),'Amy Stewart:Jennifer Brown'!B3:B8,0))

Any advice will be greatly appreciated.