How2create ONE summary report pulling from 12 different fields, with 5 different categories in each field, that are all on the same record?

You probably cannot do this with your current database design. If you had the convoy of a parent table where the children were these 12 child record for the differnent reference assets, the.n the analysis would be much easier.

You could set up a process that when the Parent is created, it automatically creates the 12 child records. These 12 child record would be more like the traditional setup where 1 project has many tasks, and you update the child record tasks as they get completed.