remove entire row from the whole workbook contains a persons name.

I have been trying various ways to look at the entire workbook and look for a persons name. If the name is found the entire row containing that name should be removed and the rows below it shifted up. (don't want any gaps).
I don't know what would be better, a cell to populate that the macro looks at to get the name, or a popup window that asks for the name to look for. Either way is good. In the example the macro would look for name 3 and remove its entire row from all the sheets.

One thing to keep in mind is that the name might or might not be in column A. It might be anywhere in the row.

Try

Sub test()
    Dim myName As String, ws As Worksheet, r As Range, rng As Range, ff As String
    myName = InputBox("Enter name")
    If myName = "" Then Exit Sub
    For Each ws In Worksheets
        Set r = ws.Cells.Find(myName, , , 1)
        If Not r Is Nothing Then
            Set rng = r: ff = r.Address
            Do
                Set rng = Union(rng, r)
                Set r = ws.Cells.FindNext(r)
            Loop Until ff = r.Address
            rng.EntireRow.Delete
        End If
        Set rng = Nothing
    Next
End Sub