Returning a list of parts from reference date

Hello everyone,
Thanks in advance for looking. I am looking to dust off my Excel skills that have laid dormant for a few years, so would appreciate any help that may be on offer...

I am trying to create a relatively simple product assembly price list from an export I made from our now defunct MRP software.

I have a list of product assembles which contains multiple rows for each product (one row for each component or raw material assembly) and I wish to compile this into a multi tabbed spreadsheet.
I have attached an example of how the data is laid out.
There are several hundred different assemblies but the data all follows the same pattern:

Product Code | Component | Price

Ideally, I wish to separate the data so there is a second tab that only shows the total cost price for each assembly (so that the product code only shows once).
Note that each product may have a different quantity of parts, so some kind of LOOKUP function is needed to reference the first column containing the product code.

Excel Query.jpg

Secondary to this, I will be looking to setup a Raw Material tab which will contain the prices for materials used in the assemblies.
I have this list, but it would need to be cross referenced from the main assembly list as these prices fluctuate.

Tab 1 - Raw Materials list (prices updated occasionally manually)
Tab 2 - Assemblies made up of the raw materials (the raw materials are listed in my data, but I need to create 'new' versions that references to the first tab)
Tab 3 - Simplified list of completed assembly prices taken by refencing the assemly data in tab 2

Happy to elaborate further if anything isn't clear.
Hope you guys might be able to point me in the right direction!

Thanks so much in advance for any responses.
I have now attached a spreadsheet which shows an example of the data I am working with.

Ideally, I would have a tab which holds all of the Raw Materials which can be updated manually as prices change, a tab for the product assemblies which reference both the raw materials list but also the sub-sub assemblies and then a third tab to just have a product list and total cost price.
The data I have is a long list that appears as shown (the full list also includes hundreds of different product names/codes obviously) so I am hoping I can use reference cells rather than having to manually rebuild every single assembly as there are around 700 of them!

I envisage something that makes it possible to "build" assemblies for products as new ones are made but also maintain the existing assemblies as they are.

Ideally I dont want to have a separate tab for every single product as there are so many of them and it would greatly increase the margin for error when building the final price list.

Any help greatly appreciated

Hi there,
I am looking to create product bill of material based on a tab containing all my raw materials and then on other tabs I will build my products.

On each row I want to use one data validation dropdown cell to select the type of raw material (wood, plastic, screws etc) and then a second to choose the specific item from that category, but all of my raw materials are in one list all together.

Is it possible for the second data validation cell ("Item" in column C) to ONLY show the items that fall unter the category of the first one ("Item Type" in column B)?
Essentially using the first data validation dropdown to filter the second?

I have attached a sample worksheet to demonstrate.Attachment 866960

Any help greatly appreciated.