Using a formula to transfer information between sheets, in different rows

I would suggest a different approach using an event driven macro.

Open the VBA editor (Alt F11), select the ThisWorkbook tab in the Project explorer pane on the left and paste in the following.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = False
Dim Cell As Range
Dim Sheet As Worksheet
Dim M As Integer
For Each Cell In Target
    If Cell.Column = 1 Then
        For Each Sheet In ThisWorkbook.Sheets
            If Sheet.Name <> Target.Parent.Name Then
                For M = 2 To Sheet.Cells(Cells.Rows.Count, 1).End(xlUp).Row
                    If Cell = Sheet.Cells(M, 1) Then
                        If Sheet.Cells(M, 2) <> "" Then Cell.Offset(0, 1) = Sheet.Cells(M, 2)
                        If Sheet.Cells(M, 4) <> "" Then Cell.Offset(0, 3) = Sheet.Cells(M, 4)
                    End If
                Next M
            End If
        Next Sheet
    End If
Next Cell
Application.EnableEvents = True
End Sub

This will add both the e-mail and education values if they already exist on another sheet when an entry is made.

To update an existing sheet, simply select the names, copy and paste back upon themselves.

Hope this helps.