Assuming you have a list of the names (say, A2:A100) on your main sheet. On
your main sheet, right click the sheet tab, view code, paste this in:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
On Error Resume Next
Sheets(Target.Value).Activate
If Err.Number < 0 Then
MsgBox "No such sheet exists.", vbCritical, _
"Sheet Not Found"
End If
On Error GoTo 0
End If
End Sub


If you want a fast-way to get back to the content sheet, simply record a
macro of you selecting your content sheet. Then, Under Tools-Macro-Macros,
assign your newly recorded macro to a shortcut key for ease of use.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Remington" wrote:

I have a very large workbook with multiple tabs each represented
aphabetically with a client name. I want to do something to more efficiently
navigate through these instead of using the scroll buttons at the bottom. I
have a content page set up as a tab and thought I could run a macro or
something to bring me back to that, then click the client name from the list
to return to the desired tab, but I am having difficulty with this. Any
ideas?