excel spreadsheet for inventory management

I was curious what i would need to do to create an inventory sheet. Specifics: i would like to be able to input my inventory and then on another page input each invoice and type the item in | or drop down from a menu and have it subtract the quantity from the inventory.