How to best pull data from a matrixed sheet of dates and milestones into a project sheet?


I have a team that is updating date estimates in a large sheet. I'm looking to create a project sheet from that matrix/range. I'd like generate the sheet with links at the same time so that when the team revises dates in their sheet the project sheet updates as well. I don't want to have to manually create Column A entries and 1000+ links in Column B (See attached example)

Does anyone have a silver bullet or advice?