Dynamic Ranges from Different Sheets Question

dynamic_ranges_and_sheets_question.xlsx

Hello all

I´m having problems with the max formula using dynamic ranges in different sheets.
I need to use ranges involving the last rows of different sheets, but the problem is that each of them are updated daily (new rows are added).

Please check the attached file for a more detailed explanation of the problem.

I´ll highly appreciate any help you can provide.

Thanks in advance.