Formula to Compare and Copy to New Sheet Multiple Matching Records

[virgIris13]

Hello,
I have a list of 80k+ records that I need to search through and pull only those that match a master list. The master list of records needed is in Sheet 1 column A and the list to search is in CCD Files worksheet Column A. I cannot figure out how to copy all of the record (all cells in the corresponding row) or how to automate the process so the corresponding records are copied to a new sheet collectively. There may be multiple corresponding matching records for every master record listing. I have attached an example spreadsheet. Appreciate any formula suggestions or other advice you may share. Thank you. VirgIris

[tgsekhar]

Use Advanced Filter. Ensure you have field names for Table Range, Criteria as well Output Range.

[virgIris13]

I am giving your suggestion a try. Will let you know if it works. Thanks!