I have a fomula [=MAX('Enter-Exit Page:9'!J59)] that gives me the MAX value of the values in Cell
J59 in each sheet in a workbook.

The formula aboves works great up until page 9, but if there is 20 pages and i have page 10 active,
i ONLY get the MAX value up until page 10 and it will not include pages 11-20.

Is there a LAST PAGE formula or some way i can change the formula to show the Max value of ALL
values in ALL sheets in J59 ?

Hope i am explaining it correctly.


Corey....