Hi,

Sheets are named "Jim" "Tom" "Judy" etc. The MASTER sheet
also has these names in a table. I want to click on a cell
containing "Tom" and have the code jump to the Tom sheet.

I tried this:
AAA=Activecell.value ' the cell contains word "Tom"
Sheets(AAA).select 'should find Tom sheet

But I get an error message, probably because VB is
expecting the AAA to be in quotes, and it's no recognizig
that AAA is a variable value.

Help appreciated
Paul