Results from Multiple Tables

While working on a project I found that I have too many tables that can be a possible output to a single location. I am looking for a formula to have 1 cell look at all 12 possible cells and decide which is the correct one. Out of the 12 possible cells only one will have information at any given time so there isn't a chance of multiple returns. I have attached a sample sheet that is a copy of my actual worksheet with some notes.

Thank you in advance!