Summarizing and aggregating for the same code from multiple sheets
I have 40 sheets containing following column with example (example for one sheet only):
Equipment ID | Equipment Group | Part Name | Quantity | Unit Price | Total Price
11MBX21 | AAF | Bearing | 2 | 150 | 300
11MBX22 | AAF | O-ring | 1 | 50 | 50
11MAK10 | BAC | Sensor | 2 | 500 | 1000
11MAD15 | BBA | Switch | 3 | 200 | 600
The same equipment code might be used in other Sheets.
So ... I need to have following one report summary:
Equipment Code | Grand Total Price
AAF | 1500
BAC | 1000
BBA | 8500
Any idea how to achieve this?