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

RFornasiero

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?

Thanks!

elicos

You need to add 2 helper column and use a vlookup or index match formula

RFornasiero

Thank you, @elicos ! I'll give this a try.