My question is kind of difficult to explain, so this is trying my best.

I am making an Excel workbook full of NFL player data. Basically, I am compiling lots of tables found online into one, master table. My problem is that each one of the tables usually has different amounts of players. For example, one table I find has stats for 50 quarterbacks in the league, while another only has 32, so I can't just copy an entire table's data in because then the statistics don't align with the proper person in my current table. And since there's so many players in my master table, it would be way too time consuming to find the data for each player I want and only copy that.

So here's my question:

Is there a way that I can have Excel search a spreadsheet for a specific entry under a specific table heading (Example: "Tom Brady" under a "Player Name" heading) and then import the data for that entry from that workbook into my current workbook? And then is there a way I could copy that into other cells so that Excel searches another spreadsheet for all the player names in my current spreadsheet, and then imports that data into my current spreadsheet?

If this still doesn't make sense, I'll try to illustrate it.

My master spreadsheet has 32 quarterbacks listed on it. My current spreadsheet does not have data about how many times they were sacked. I found a table online with this data, and imported it into its own Excel file. However, this new spreadsheet with the data I want on it has 50 quarterbacks on it, which is more than the 32 that I need. Can I have excel search the new spreadsheet for the names on my master spreadsheet, and if it finds a matching name, import their sack data to my master spreadsheet?

I hope I explained it well enough. Thanks everyone!