Return Maximum Value from multiple sheets

[NickMinUK]

I have a dozen or so sheets with a date in the same cell on each sheet
Each week I add a sheet infront of the last sheet (called End). Th
front sheet acts as a total sheet & sums all the values in th
following sheets (hence the purpose of the "End" sheet - so that I ca
sum all sheets from the first to last without adjusting formulas).
need to return the latest date, which will be from the penultimat
sheet, but =max doesn't work accross multiple sheets. Is there
solution? Any help much appreciated. Nic

 

[Frank Kabel]

Hi
for me MAx works for multiple worksheets e.g.
=MAX('start:end'!A1:A20)