how to consolidated spreadsheets with different structures into a master file

[Kayview1]

Hi there, I used a macro to consolidate a couple of spreadsheets. But would like to consolidate my spreadsheets into a summary tab. Please advise on how I can go about to do this? The structure of the worksheets are similar they are just not in a table format (more like T format) and some of the cells doesn't align with the same cells as other spreadsheets. Please advise.

 

[Kayview1]

The objective of consolidating these files are to have a summary file to analyze the whole project. Each separate worksheet should have the detail/breakdown piece of different entities but would like an overall overview in a summary tab.