Corey wrote:
Is there a way to display in sheet1 the MAX value of a cell through ALL
sheets in that workbook ?

Say [T55].
I want this cell to display the MAX value in all sheets [J55].

I want to use this as a quote number, but not every sheet will have a value.
I tried a MAX formula, but i need to know the 1st and Last sheet names
before hand.

Regards

Corey....

Hi Corey,

Have you looked at the following topic in Help?...

"Refer to the same cell or range on multiple sheets"

It seems to me that this is what you are trying to do.

Ken Johnson