Calendar-based visual dashboard from project progress data

Dear all, I once had a much more complicated problem and someone on this forum solved it within hours so I thought I would give it another try.

[Note that the details of my problem and objective are included in the attached worksheet.]

We have a small team of members. Each member is assigned "projects" comprising a number of "milestones" (start, milestone1, milestone2,..., end). Each milestone has an expected completion date. Upon completion of a milestone, members would input it in an excel table (ideally through a form since not all members are computer savy).

The "data" are therefore composed of various "projects", "milestones" (for each projects), "expected dates", "actual completion dates", and other project-specific fields.

The goal: to use these data to produce a calendar-based visual dashboard presenting the "degree of completion" of each project using common colour codes (green, orange, red).

I have some knowledge of VBA but I am self-taught, so definitely not an expert. I have started working on this problem but it proves surprisingly difficult given my skills set.

One of the main problem I face is to make my code flexible enough to accomodate addition and deletion of projects.

We have a very small budget but if this proves too complicated, even for the experts on this forum, we would be willing to consider paying for a job well done.

Many, many thanks in advance to anyone outthere willing to help us!!!