Pulling out certain Zip Codes in Sales Report

Hello - I'm new to this forum and I'm hoping to find some help. I know some Excel basics but nothing too detailed for what I need to do. We have a quarterly sales report in my office that is broken up by zip codes in one of the columns and what I need to do is based on the zip code determine which sales rep that line belongs to.

I have a list of which zip codes belong to each sales rep - but is there a way I can enter in one reps list of zip codes to automatically search the workbook and filter all the matches to a new sheet? This report is large and it takes up quite a bit of time to do this manually so I was really hoping there was an easier way to do this.

Thank you so much in advance for any help you can provide.