MACRO: Find a matching cell of another sheet

[redsh0es]

I think this one's a sequel to my last thread - http://www.mrexcel.com/forum/showthread.php?t=616832
[Yeah, I know i'm really d*mb. Sorry!]

credits to my saviors SteveO59L and Snakehips

I'll just make this simple to understand.

*Again, I have first sheet, named "SUMMARY"
*On Column A, I have list of names
A1: Star
A2: Moon
A3: Sun
A4: Clouds
*these cells corresponds to the Cells of different sheets
A1: Star = E3 of Sheet 1
A2: Moon = E3 of Sheet 2
A3: Sun = E3 of Sheet 3
A4: Clouds = E3 of Sheet 4

this is what I should get:
1. I select the cell A1 as an active cell
2. press the button (with the macro on it)
3. I will automatically go to the sheet where "Star" is located

Please don't hesitate to ask if my explanations are not understandable.

Thank you very much!
Dorothy

 

[AlphaFrog]

You could create a hyperlink for each of your names. When you click on that name, the hyperlink will automatically go to the sheet.

Video: Excel Drag Hyperlinks Video
Video: Excel Hyperlink Tutorial

 

[redsh0es]

I can do that but the problem is, the users should not create any changes (such as creating hyperlinks) on the file.