Formula to avoid duplication of results

I need a second set of eyes on my work as I am hitting walls on how to tackle this problem.

I started thinking about doing an indirect across tabs, but forecast uses different columns for the data than the forecast, so that won't work.

I know I am making this harder than it has to be, but I think I forgot to bring a string and a lamp to take through this labyrinth (mind you I am working on multiple excel files for multiple parts of the organization).