I would like to find the maximum value from a cell (A1) on 40 similar sheets
containing 200 prices in Column A

Example: (using 4 different sheets)
Result Sheet Sales Sheet 1, Col. A Sales Sheet 2, Col. A, Sales Sheet 3
Col. A
1.25
1.36 0.95

Formula would record the value & its associated sheet number for this value.
So the Result Sheet would look like below:
1 A B
2 1.36 Sales Sheet 2
--
Carolan