Using VBA to populate cells based on a criteria in another tab

Hi, I really want to learn VBA and its many uses in excel, but I'm more of a hands on learner. I have a simple project I'm trying to do for work that I know is possible through VBA, but I don't have the expertise to do it.

Essentially we have a master list of property managers (PM) addresses and owners etc... in a tab called "Property List" and tabs for each of the property managers in the same file. I would like to populate the individual PM's tabs with their properties based on a search/copy/paste of the "Property List" tab

Row 1 contains the headers ... there are 10 columns of information
Row 2 begins the data
Column 1 contiains the property manager Initial (the search criteria)

I've tried this code but get a runtime error object required

Sub copyrows()
     
    Dim tfCol As Range, Cell As Object
     
    Set tfCol = Range("A:A") 'Substitute with the range which includes your True/False values
     
    For Each Cell In tfCol
         
        If IsEmpty(Cell) Then
            Exit Sub
        End If
         
        If Cell.Value = "BC" Then
            Cell.EntireRow.Copy
            Brad.Select 'Substitute with your sheet
            ActiveSheet.Range("A65536").End(xlUp).Select
            Selection.Offset(1, 0).Select
            ActiveSheet.Paste
        End If
         
    Next
     
End Sub

Any helpful hints or suggestions is greatly appreciated. I would really like to learn this stuff so if you have suggestions on tutorials etc... I'm open!