Dashboard Automatically Updating with Data on Newly Added Sheets

I have a spreadsheet which has a seperate sheet which holds information on different projects. I was planning on adding a macro that creates a new project by copying a template sheet, which will then appear on a list of sheets (see column A of dashboard) - this bit is fine and currently works.

What I am really after is for a user to select a project from a drop down (also completed this part - see cell D9 Dashboard) which then shows the relvant cell(s) from that sheet. I have a work around in place at the moment with an IF function but in its current state this would need a new argument adding every time a new project is added, which is something I was hoping to avoid.

I have no idea how to do this last bit and it is really frustrating as it is the last piece I need to have the automation I am after.

I am not that familiar with VBA, having only ever copied and pasted relevant code.

Hope someone can help

Thanks mikeTRON, I'll take a look at this, yes sorry I shouldve removed contract 3, I was playing around with the layout

It works and it is glorious! I love it when a plan comes together