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

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.