userforms calling cells from a different sheet

[seansimi]

Hello, I am looking for some guidance. This is my first time using macros and userforms in excel 2007. My problem is that I am trying be able to select a cell in sheet1 and it brings up a userform with labels that call up the information that I need that's in sheet2. Along with this I also need when I select another cell it brings up the information that is specific to that cell. An example would be if I have cell A1 as John S. I select it and it brings up all the information I need for him and in A2 I have Mary B., if I select this cell it brings up her information, etc., etc.

I am not really sure where to start. Thanks in advance.