Assuming that the range of interest for your worksheets is A1:A100, and
that B1:B3 contains your sheet names, try the following...

Maximum value:

=MAX(SUBTOTAL(4,INDIRECT("'"&B1:B3&"'!A1:A100")))

Sheet name:

=INDEX(B1:B3,MATCH(MAX(SUBTOTAL(4,INDIRECT("'"&B1: B3&"'!A1:A100"))),SUBTO
TAL(4,INDIRECT("'"&B1:B3&"'!A1:A100")),0))

Both these formulas need to be confirmed with CONTROL+SHIFT+ENTER, not
just ENTER.

Hope this helps!

In article ,
"Phil" wrote:

I am using Office Professional 2003. I want to extract the MAX_VALUE in a
range across several work sheets. Once the MAX_VALUE is determined in the
range, I need to identify the sheet that value resides on.