Move Data Associated with a Zip Code to Another Sheet

magc210 Easiest done with Power Query (PQ). At least, that's my personal opinion. I replicated your example on a smaller scale. some data in the Data sheet and the PQ output in the Query-MyZip sheet.

If you are not familiar with PQ the link below point to a good place to start.

https://exceloffthegrid.com/power-query-introduction/ 

But, if your real data is indeed in a six column table and the list of your ZIP codes in one column, you can just copy the 3000 names and addresses into the first table and your 200 ZIPs into the other. Then on the Data ribbon press Refresh All and see what happens. Almost certain that the table of names and addresses for your zip codes shows up in the Query sheet within a few seconds.