Quickest way to summarize random data

We track equipment for our construction company on a crude Excel sheet shared by all project managers. At the end of each month, I summarize this spreadsheet into one master. I have attached this file below. Each cell represents a job number and row A represents the phase for which each has to be summarized. (or) if easier, it can be summarized by job number. Tab 2 ("AJE Summary") is what I'm hoping to get the end product to appear as. However, I'm currently having to prepare this manually. I am wondering what the Forum members recommend as the easiest way to summarize this information without adding manually?

Thanks in advance for your help and a happy weekend to all!

OMG This is a cracker of a spreadsheet. It is really hard to work out what is happening, however I will have a crack at it.

Bottom line, you need to change the way you collect the data, and life will return to harmony. I suggest you set up a table to collect the data, and then use a pivot table for reporting.

See sample attached. Look at the data and report sheets. This is just an example. I don't know anything about your data or how you want to report on it. I do know however that if you collect the data in a table like the one I have in this sample, you can slice and dice and report on the data any way you want.