Sum and multiply several different columns of data on different sheets

Hello,

I am trying to figure out a way to use a formula to summarize a certain task. I think it will be easier to describe what I'm trying to do and include an example of an outcome I'm looking for.

Please see the attached example workbook. I created a small example as the real workbook I'm working with has hundreds of lines and twenty-plus sheets.

I have 10 segments that all have different lengths. There are 6 maintenance types that each segment could have. Each maintenance type has a different unit cost/length. For example, segment 1 uses type A maintenance and is 0.1 units long. If type A maintenance is $100/unit length, the total is $10. Segment 2 also uses type A and is 0.2 units long. That is a total of $20. Segment 3 uses type C maintenance and is .3 units long. Type C is $300/unit length for a total of $90.

What I want to do is a summary page where I tally up each occurrence of a maintenance type and the total.

You can see the Budget Summary sheet for the "TOTAL". I just quickly did all the totals by hand, but want to know if there is a way to reference the other sheets to automatically tell me what the totals would be.

Any help is greatly appreciated.

Thanks much