Gathering & Arranging to Forecast

I have data that is located all over the worksheet, but I need to gather it and arrange so I can do some forecasting. Is there a way to grab values do the forecasting and then have a cell show the result. A UDF that passes a lot of variables or something?

I was thinking that I could use named ranges for each cell that contains a variable "D6" = namedrange 'a', so in VBA, Vara = Range("a"), Varb = Range("b"), etc.. but not sure how to forecast within VBA or if there is a better way to do it.

I've attached a sheet to give an idea of what I have now.

There is other data between the values I'm looking for so filtering like that won't work, I should have added that to my sample. I also don't want to show the sorting and arranging, I just want my final forecast to show.