I need Excel Expert for Help Combining Data from Multiple Spreadsheets

We are a sports licensing company and sell thousands of sports products. I am looking for someone who can combine data from multiple spreadsheets into a single spreadsheet. Attached is a team code spreadsheet with two tabs that shows all of the teams/schools we sell. I've also attached our price list that shows all of the items we sell in drinkware. The Arches spreadsheet is an example of what we want created across all of the items in the drinkware price list. Please note we combined the team/school codes (e.g. MLB-AAN, MLB-ADB etc.) with the item id shown in column B of the Drinkware spreadsheet (e.g. 1140-100, 1141-100 etc.). We need the same process done for the rest of the price list.