Consolidating material lists into one run sheet

Hi Guys,

I’m seeking a way to consolidate material from multiple assemblies, ant ideas?

Example: Assembly 1,2,3 and 4 all use the same 4x4 tube, just different quantities. I would like to hand a run sheet of the total amount of tube required for all 4 assemblies so the material handler doesn’t need to tally it up. Just the grand total.