Inventory management

I need help programming an Apple Numbers workbook. I have a sales tab and an inventory tab. Each sale that happens is associated with a stock number. I would like it to deduct from the inventory tab based on stock number