Create Macro to check one Spreadsheet for Data and add the columns to another

I have a Spreadsheet that has set column headers. I am looking for you to create a MACOR that will search the Serial in a second Spreadsheet, and copy over 6 additional columns of data that is found in that 2nd sheet.

I have a few sheets that have 6K items, 25K Items etc. I want the Macro to look at the Serial and search my master Sheet to pull Additional columns to add to each of these sheets.

I want this complete in the next 8 hours.