Copy rows that match values in a column of names

Hi folks.

I did my best to search the forums to find an answer that would fulfill what I need done, but I had no luck. It seems that there are hundreds of copy rows requests, but all seem to be unique in their own ways.

Essentially I have a column of company names in one tab (Tab A), and then a huge list of company names with data in another tab (Tab B). Since I can't use vlookup to copy over whole rows (Please note that I want the whole row and not only the columns listed in the sample data.. i have deleted some columns for privacy reasons), I am needing a copy row function that would essentially copy over any lines from Tab B to a new spreadsheet/tab names results or something similar, where a company name found in tab A matches in tab B. The reason I need this macro is because i have over 40000 lines in Tab B and roughly 300 lines in tab A. If I had to filter by each name (~300) , copy and paste to a new spreadsheet.. this would take hours.

I have attached sample data below. Notice that I have included a supplier name and unique number. You can alternatively match against the number since it leaves less room for error since sometimes leading/trailing spaces, etc. call for mismatches and missed data.


I whole heartily appreciate your help and expertise. This is a wonderful community and has helped me a lot before! In short, you guys are all geniuses!

Thanks again.
-Konrad