Macro to select Names from dropdown list?

Think I need some kind of Macro for what I want, just don't know where to start, so hoping someone could help me?

I have 7 worksheets.

Five with a lists of Project Names - and a brief update

One with a Drop Down list to select the Projects, and V Look Ups set up so that when you select the project name from the drop down list, you get an update on the Project.

One with all the data in list format.

So, everything is running almost smoothly. Except what I now need is:

When you select, (double click) the Project Name in the first sheet I want it to take you to the sheet with the Drop Down List of Project names, and select the Project that has just been clicked on.

Does this make sense?

Any help would be really appreciated.

Thanks, I tried a Hyperlink, that'll direct me to the page, but it won't select the project name I want from the dropdown list, unless there is something I'm missing?

I've attached the report I'm talking about.

So, as an example.

On the first sheet "Compliance", I would like for someone to be able to click on "Project 3", and for it to take them to the Project Progress worksheet, and select Project 3 from the dropdown list.

I believe it's possible, just can not find out how!!

Thanks for all your help!

That is absolutely superb!

Thanks ever so much for all your help!!!