Parts Pull List

I have list of standard furniture items that have unique parts. I need an excel sheet that will create a list of needed furniture items with their itemized parts and adjust the numbers of parts needed based on the total number of furniture items. Example: Bookshelf 20 has 6 named parts. I want to be able to say, "for this order I need 4 "Bookshelf 20s" and the sheet will create a list of all the parts and how many I need to fill this order. Going further, that order might need 5 other furniture pieces with their unique parts. I need to be able to print a sheet with all of those counts to hand to a warehouse person to pull. As my inventory is growing, I would need to be able to add products and their parts myself.