VBA / Macro help needed to create summary report from another sheet

Folks,

Please help me to create a summary report in sheet called “SUMMARY” from the master sheet “ALL JOBS”.

I have tried to create the same report by using pivot table option, but its giving lot of troubles since the data volume is huge, data vary all the times and sometimes Columns will come without header.

Then I have tried the same with COUNTA formula but this time I got another issue i.e. if I add new row data in the master sheet then I need to modify the formula each time.

I have attached the work book of what I am trying to accomplish.


Thanks in advance for your time and expertise