Replace Index Match with VBA - Multiple Criteria - Thousands of rows and columns

I have attached a copy with more data so you can see what I mean about patterns etc. Most of the people using this document come to look at for info, not to analyze it. Seeing the pretty colors and patterns is what helps, not the numbers themselves, although they do need those as well.

What I am looking for is a way to enter the code I need to put in each little cell as VBA instead of array formulas.