I have a worksheet that has many columns. One of the columns contains Vendor
Sku Numbers and another column on the same worksheet contains Price
information for that Part Number. I need to update pricing information
regularly based on a new worksheet that I receive which has the part numbers
and new pricing. How do I update pricing for thousands of parts without
having to look at each row and column.

example:
wks "A":

Vendor SKUNumber Descr Price
0120 Bulb 1.35
0115 Pen 2.68

wks "B":
Vendor SKUNumber Descr Price
0120 Bulb 1.44
0115 Pen 2.78