Help with a If value then paste, but searching through a range for the matching value

Right now I am using this to help me update my roster. I take an outside roster, I copy the team then go click a corresponding hyperlink in my workbook that kicks off the macro below. It'll work just fine but If "Natalie" and the others get shifted as they occasionally do, then I'm going to have to update all the ranges. Instead I would like to have only one code that searches through row 4 for the value, when found it then clears out that column's rows 6-30 and then pastes values.

Sub PasteNatalieRoster()
    If Range("L4").Value = "Natalie" Then
    Range("L6:L30").Value = ""
    Range("L6").PasteSpecial xlPasteValues
    Else: MsgBox ("Error: Has Natalie Moved?")
    End If
End Sub