Inventory and Logs

Hello. I am trying to combine an inventory list and a log of use (IE: user uses X g of chemicals, have the amount subtracted from the amount registered in the inventory list). How would you do this?

This is 2 separate tables (singular excel, 2 tabs). Some chemicals there are smaller containers in different locations, so I believe there would need to be an additional calculation/input for the location they were taken from.