VBA Help needed. Thanks.

[tottallyoff]

Here is my problem. This may seem trivial, but I am just starting out with VBA.

I have a spreadsheet with many worksheets in it. Sheet 'Names' has personal data for a person. Sheet 'Credits' has more information about that person's work.

Here is what I am trying to do:

When a cell in sheet 'Names' is clicked, the user is forwarded to cell containing the same name on sheet 'Credits'. I know how to do that with hyperlinks, but its not going to work becuase the list of names is updated.

What I am having problem with is:

1. How do I make the Sheet 'Names' react to clicking of the cell? Do I use procedure 'Worksheet_SelectionChange()'?

2. How do I highlight the cell on sheet 'Credits'?

3. How do I compare values in cells that are on 2 different sheets?

The code to highlight the cell is this, i think:

For x = 3 To <some number> 
    If Cells(x, 1).Value = <value of cell In sheet 'Names'> Then
        Columns(x).EntireColumn.Activate 
        x=x+1000000 
    End If 
Next x

I know this may seem trivial, but I am very new to VBA.
Thank you.