generated parts list from list of assemblies

Hey All,

I want to create an excel sheet that will allow me to key in a list different assemblies and generate a parts list from that. Each assembly uses a different combination and quantity of parts which I have listed in a sheet named after the part. I want to be able to put in several assemblies and have excel tell me a list of parts and quantities I need for all the assemblies. I have attached a simple example, the Assemblies sheet is where I list the assemblies (A, B, and C) and their quantity. The Parts List sheet is what I want to be generated from the information on the first sheet and the assembly definition sheets (A, B, and C)

I just want to know it's possible and have a direction to go. Can I just use formulas or do I need to get into VBA and Macros?

Thanks,
StaticChanger