userforms calling cells from a different sheet

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.

attach a sample file with all informations

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Column = 1 Then
    name1 = Target.Value
    Call nfind(name1)
  End If
End Sub

Sub nfind(name1)
Dim c As Range
With Sheets(3).Range("A:A")
  Set c = .Find(name1, LookIn:=xlValues)
  UserForm1.lblAddCap.Caption = c.Offset(0, 1)
  UserForm1.lblAdd2Cap.Caption = c.Offset(0, 2)
  UserForm1.lblStateCap.Caption = c.Offset(0, 3)
  UserForm1.lblZipCap.Caption = c.Offset(0, 4)
  UserForm1.Show
End With
End Sub