I have 24 sheets name Press1 through Press24. I used the MAX fuction to find the highest number from cell C177 across all sheets. What I need to do is produce the name of the sheet OR press number from cell A4 (name is in the same place on each sheet) where the highest number resides. This is the formula I used to get the highest number, but can't figure how to get name where it came from. Tried a combination of INDEX & MATCH but to no avail. Any ideas???

=MAX('Press 1:Press 24'!C$177)