Save yourself the headache and use Access as suggested previously. Excel is not a database, and is in no way suitable for use as an inventory system. Access even has built in templates that will do just what you want.

You can do similar in excel, but ultimately it's not going to be fit for purpose .