Inventory Control Spreadsheet

Hello All –
I am looking for a little help on this spreadsheet.
I have been tasked with producing an inventory spreadsheet that where one of the things they would like is as they order things, items are deducted from the main inventory sheet automatically.
One of the ideas I had was to have dropdowns on an “Orders” tab that once a description is inputted and a quantity is added, it would search for the product name on the “Inventory” tab and automatically insert the number of items being ordered from the sheet to deduct from the overall quantity of items in stock.
I was attempting to use an Index / Match combination formula.
But it is not working the way I hoped. It is basing the quantity strictly based on cell location from the “Orders” tab. If the Description on “Orders” is not in the right location, Excel is not seeing the number. (I know how and why it is doing it…just can’t get it to do what I want.)

I am wanting it to find the “Description” of item from the “Orders” tab, find the corresponding on the “Inventory” tab, then automatically input the quantity in “Column G”.
I have attached a watered down version of my sheet for everyone to look at.
As usual, I appreciate any help that may be given.
Thanks.
Dave

Hello John -

Thanks for the quick assist. I appreciate the note regarding the free templates. The person who made the request was looking for a certain level of customization.

Hope you are ok over there in England with the heat....
Have a great day.
Thanks again.
Dave