Help With compiling Data

Dear Sir's,

please see attached file ,

I need to compile the tab titled "Z4071 report" in the tabs marked "Phase 1" and the same thing for "z4067 report" in the "Phase 2" tab. Ideally the report tabs could be continued and could automatically populate the information in the report tabs. As shown in the Phase tabs, this information needs to be reflected per asset (column B in the report tabs), per pay item (column E). It would then add up the units in column F and display this data in the respective Phase tabs. There may be repeated pay items in a given asset, in this case the quantities should be added together. Additionally, if another report could be generated that would assign the values to the quantities placed on a given day, per asset. This would be extra.

Thanks in advance.