Create a new table from two updating worksheets under various conditions

Hi guys,

I would like to create a new table based on data from two worksheets. The first one (RAW DATA, see attachment) includes values such as 00-001 as the final product and below this row its components (S1, D2,...) are listed. However, sometimes another not important value (which is different to the format xx-xxx) like 70450 is included which is not relevant for the FINAL table. The second workbook included worksheet related to a specific month (e.g. Month1 ). It shows how much of the final product like 00-001 was produced in Month 1.

The aim is to create a new table, to show how much of the products 00-001,...... was produced and how much of their components were like S1, S6 (but not 70450) were used.

I'm not sure whether a Pivot table could be used or whether some if-functions could be used. My previous attempts couldn't match all the data based on the conditions.

I attached a sample workbook.

I hope someone could help me.

Cheers, Paul