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?