Using Macros as a navigation tool

[lula24]

Hi
I have a 'dashboard' worksheet in 2010 and want to be able to click on a cell in this sheet and have it take me to the assigned worksheet. They are all in the same workbook.
e.g if i click on Leadership i want it to take me to the Leadership tab, Skills to take me to the Skills tab etc
The 'dashboard' will be the only viewable sheet in the workbook until one of the items on the page has been clicked.

I have a very basic understanding of macros and I'm not sure if this would work or if i should use a formula instead?

Thank you

 

[wigi]

If you need to unhide a worksheet first, then formulas won't work.
Inserting a hyperlink won't work.
You will need to use macro's. For example, check out Application.Goto