Hyperlink different worksheets from a drop down list

Hello All,

I'm new to excel so please bare with me. I have the rough makings of a project tracking dashboard and I want to create a hyperlink from a drop down list. For example, on the attached sheet in C3 on dashboard sheet, I would like to create a link to either Project One or Project Two work sheets based on what is chosen from the A3 drop down list.

I have a formula in there but it doesn't seem to work. Any help would be greatly appreciated.

Thanks,

As you have spaces in the sheet names, you have to incorporate apostrophes around the name, like this:

=HYPERLINK("#'"&A3&"'!A1"," click here")

Hope this helps.

Pete

Perfect! Thank you very much.