data extract

aayushmanmishra 

As variant that could be Power Query with two steps if create helper table with codes to filter

as

let
    Source = Excel.CurrentWorkbook(){[Name="SourceData"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each  List.Contains( Filter[AGENT_ID], [AGENT_ID] ))
in
    #"Filtered Rows"

aayushmanmishra 

If you don't have Microsoft 365 or Office 2021, the FILTER function will not be available.

As an alternative, you can use Advanced Filter:

1) Create a Criteria range like this - I created it in I1:J3:

2) Select A1:H1 on the Scrubbed sheet., then select Data > Advanced.

Excel will display a warning, click OK.

Populate the dialog as follows:

Tick the option button ' Copy to another location'.

Click in the List range box and select the data on the source data sheet.

Click in the Criteria range box and select the criteria range on the source data sheet.

Click in the Copy to box and select the headers in A1:LH1 on the scrubbed sheet.

Click OK.