Hi,
I have a workbook with many worksheets. In the first sheet there are numbers in each cell of column 2. Numbers will be added to this column as necessary. The numbers have been used to name each of the other worksheets. Each of the numbers has been allocated to a worksheet. I want to be able to double click on a number in the first worksheet to jump to the worksheet which is named by that corresponding number.

I'm sure this can't be that hard - tried this but it only works on the first cell and target sheet. Any ideas?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub
v = Target.Value
For Each sh In Worksheets
If sh.Name = v Then
Cancel = True
sh.Activate
End If
Next
End Sub