Reporting multiple criteria from multiple sheets
I am trying to create an output (maybe a report?) that shows multiple criteria from multiple sheets. I'd like to show each project (I have a sheet for each), with the assigned personnel by "task type" and "priority". I'm not really trying to do true resource loading. I just want to see number of tasks assigned to each person that are "task type" A or B AND "priority" A, B or C (See my example below). Creating sheet summary fields for each person by task type and priority seems labor intensive. It'd be even better if I could add some color to it (high priority over 9 project tasks = red).