I designed some additional sheets to demonstrate, how I would start with such task. Maybe you get some ideas.
In general - all data entry is done in tables. When you want to display it otherwise, you create a report. P.e. your sheet 2017 would be something like ReportProjectsYearly, where you select a year number, and all projects active in selected year are displayed. Having data entry in tables makes writing formulas much easier.
|