I have 10 worksheets, sandwiched between Start & End dummy sheets. Within
each of the 10 w'sheets, i have specific cells with formula to tabulate
certain sums.

There is a Summary page (in front of Start) which has a formula cell to
calculate the MAX value across the same cell in all 10 w'sheets. Within each
cell, i have A1 cell that has text title while C2 contains the cell to find
the max value.

I managed to grab the MAX value to display on the Summary page. However, i
have an additional criteria where assuming the MAX value came from Sheet
1(C2), is it also possible for the formula to 'grab' the text displayed in A1
(text title) to show on the Summary page?

I tried with this formula but doesn't work:
=IF(MAX(Start:End!C2),(MAX(Start:End!C2)=A1),"")

Any suggestions?