My first thought is why don't you hyperlink to the tab from the cell.
You can have a tab called "Bed Base - Double" and in your 'Quick Data' tab cell A2 - "Bed Base - Double" can also act as a link that takes you to the corresponding tab.
R-Sole14's post in Excel VBA was marked as the answer
Hi Mark,
Try the below. I haven't really tested it as I've only got Excel on a poo poo Macbook at home and it's a pain in the arse for VBA. I have removed the exit functionality of the sub so you may find it reduces performance. I can have another look when at work Tuesday if needed.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rg As Range
Dim rg1 As Range
Set rg = Columns("A:K") 'Column containing names to sort
Set rg1 = Columns("M:W")
Range("A5:K500").Sort key1:=rg.Cells(1, 1), order1:=xlDescending, Header:=xlGuess
Range("M5: W500").Sort key1:=rg1.Cells(1, 1), order1:=xlDescending, Header:=xlGuess
End Sub
R-Sole14's post in Autumatically change Tab names in excel was marked as the answer