Button which links the front page to another page depending on a data validation cell valu

I'd like to create a button which would sit on the first sheet of my workbook. This button would link to other sheets in the workbook depending on the data validation value of another cell in the front worksheet.
ie. Cell B2 in sheet 1 has a data validation with the following list array: Ballarat, Brunswick, Canberra, Geelong, Gosford, Sydney. If cell B2 contains the value Brunswick, then it will open sheet 2 (named Ballarat), if B2 contains Sydney it will open sheet 6.
Is this possible or do I need to go about it another way?

You could use a select case statement based on the value of your cell.

Thank you Yrean,
If i understand this correctly (having done some research), the vba would look something like this:

Select Case Activesheet.Range("B2").Value
Case Ballarat
'Select Ballarat
Sheets("Ballarat").Select
.
.
.
Case Sydney
'Select Sydney
Sheets("Sydney").Select
End Select

Would this be correct?
This is my 1st time writing vba.

I've received an error message which says Complile Error: Invalid outside procedure.
Am I missing some code or have I mis-named something?

Unknown. If you'll post your code or workbook I'll write it up real quick. Best way is to post the workbook, but I understand that sometimes they have data we cannot or do not want to share.

Hi Yraen,
Thanks again for your assistance.
My VBA code is:
Select Case Dashboard.Range("C6").Value
Case "Brunswick"
'Select Jenny + Gemma
Sheets("Jenny + Gemma").Select
Case "Ballarat"
'Select Cheryl + Leigh
Sheets("Cheryl + Leigh").Select
Case "Sydney"
'Select Imranm + Mark
Sheets("Imran + Mark").Select
Case "ACT"
'Select Craig + Josh
Sheets("Craig + Josh").Select
Case "Gosford"
'Select Stuart + Ben
Sheets("Stuart + Ben").Select
Case "Coffs Harbour"
'Select Jacob + Martina
Sheets("Jacob + Martina").Select
End Select

The sheets are:
Sheet1 (Jenny + Gemma)
Sheet2 (Dashboard) - this is my front page with data validation in cell C6
Sheet3 (Cheryl + Leigh)
Sheet4 (Imran + Mark)
Sheet5 (Craig + Josh)
Sheet6 (Stuart + Ben)
Sheet7 (Jacob + Martina)

My system won't let me attach the whole workbook
Thanks again.

Hi Winon,
I'm afraid I had a little trouble working out your solution.
But thankyou and I appreciate your suggestion re "Please Consider"

Hi Winon,
Thats perfect.
Thankyou

Glad you got it worked out. Sorry I didn't make it back here quicker.