I have two excel spreadsheets, one that is complete with product part
numbers, item descriptions, prices, quantity, photo url's, etc. I get a
daily update in the form of a spreadhseet with part number and quantity only.

Is there a way that excel can recognize that column A in each worksheet are
part numbers, and if the part number in column A of each worksheet matches
that excel should update column G with the new quantity (column B from
worksheet 2)?

A simple cut and paste will not work as there are different numbers of rows
in each worksheet as part numbers become discontinued. Any help with this
would be appreciated. Thank you.