Understand that Excel is not a relational database program, and that is what you really need to do this. It’s not the right tool for the job.
A simple list of items can be built in Excel, but it is impossible to get any meaningful reports out of Excel. There are other, vastly superior database programs out there that work better and are easier to use.
Download and try the Yard Office program that Patrick1544 posted. MUCH better than anything you’ll find built in Excel.