Worksheet_BeforeDoubleClick - multiple cells, multiple sheet activations

Hello,

I am looking to be able to double click on a cell to activate opening another sheet (in the same workbook).

So far I have this code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("B4")) Is Nothing Then
Else
Sheet2.Activate
End If
End Sub

Which works fine for double clicking on Cell B4, then opens Sheet 2.

How do i add multiple conditions to this in the same Sub so I can open more sheets?

i.e. double clicking
B4 = Sheet2.Activate
B5 = Sheet3.Activate
B6 = Sheet4.Activate
B7 = Sheet5.Activate

and so on..

Any help would be greatly appreciated I am struggling to figure this one out.
Thanks

Yes, double clicking from the same sheet.
It's just text that's in the cells I wish to double click on.
The premise is that a person will go onto Sheet1, find their name and double click on it to take them to their designated tab.

Thanks for the above code Norie.

This works, but only if the sheets are all unhidden.

Is there a way for it to search for and unhide the correct sheet?