Linking columns in separate worksheets
 

I have two worksheets in my workbook. I need to link two columns in each:

ex.
Part No. & Quantity

What I need is to keep track of inventory. I want whatever number comes off
of the Inventory disbursement sheet, Quantity column, to reflect in the
Current Inventory Quantity/On Hand column. But I need it to go by Part No.

Is this possible