Welcome to the forum crnek1. Like Limor_OP's but since you already have the relative MAXs worked out in column A of Summary modify Limor_OP's like this
Formula:
=INDEX($C$2:$C$7,MATCH([@Records],N(INDIRECT("'"&$C$2:$C$7&"'!A"&ROWS($G$1:G2))),0))
the results are the same at my end.
You could also eliminate the Sheets column (C) by placing a hard array of sheet names in Name Manager named Sheets and replace the $C$2:$C$7 references with Sheets
Sheets |
={"Adam","Corey","Luke","Rick","Lander","William"} |
Bookmarks