merge 2 spreadsheets
 

I have two spreadsheets One is a smaller list of names with a heading called
vendor number in one of the columns.
I have a monthly master spreadsheet that comes out that contains many vendor
numbers that I don't want to track.
How do I merge the two sheets to update the smaller sheet with just the
vendor numbers that are listed .