You left named ranges unedited. I defined all referred ranges as dynamic ones for all formulas, so now the formulas adjust automatically when you add data into sheet 2017.

Edit: About Dynamic Named Ranges/Dynamic Names.
A Name or Named Range is dynamic, when:
1. The value of Name or returned range of Named Range depends on range of data source, e.g. on number of rows in table (MaxRows, DataProj, etc. in attached file);
2. The value of Name or returned range of Named Range depends on position of active cell on worksheet when you define the Name/Named Range.

Attached Files

Project_Status_updated.xlsx (93.4 KB, 11 views)