I don't know how you determine the appropriate worksheet, but maybe you could
use a hyperlink to jump to whereever you want to go.

Todd wrote:

I'm creating a large spreadsheet, made up of many, many individual
worksheets. The information captured on each worksheet is summarized on a
'Summary Sheet' for ease of tracking.

For example, the information manually entered on Tab 1, Tab 2, Tab 3 will be
Summarized on the first tab of the workbook, which is the 'Summary Sheet'

Eventually, there will be so many individual worksheets it will be difficult
to find the individual sheet to update it as necessary.

Is there a way, to jump to the appropriate worksheet from the 'Summary Sheet'?

--

Dave Peterson