MAX would start working with the first lot again, rather than the most recent
Not sure what you mean

The following will return the maximum number from A1:A3 across Sheet1 and Sheet2:

=MAX(Sheet1!A1:A3,Sheet2!A1:A3)

If you are nonetheless happy that your problem has been solved, if you could mark the thread as such it would be appreciated.

Kind regards,

Robert