So I have no Idea where to start here, if this is even possible or not...

I have a Master Supply List (currently only 3000, will probably grow to 10,000+)

Two columns hand Modules and Sub-Modules.

I can add or remove Modules and Sub-Modules on subsequent sheets, in order to get a full price for inventory costs.

I can't for the life of me figure out my last sheet, in which I am trying to attempt to create a list, based on the values of Modules and Sub-Modules in previous sheets, so that I have one list I can print that says how much of every item I am ordering, or something along those lines...

Any Idea's would be appreciated on how I might accomplish this!

If this is in the wrong forum, I'm sorry, please move it to the correct location.

P.S. (I am unable to upload the excel file, it is to large, I know that would help)