Excel inventory and invoicing

Hi I have just set up my inventory in excel. I am then going to set up my invoice in excel but when creating the invoice I want it to be able to find the items from my inventory and add them into my invoice then when i select how many were used the inventory then gets updated to lower the stock levels