Revenue Forecast

Hi everyone,

So I have a file that I use for revenue forecasting but it is very tedious because every time I get a new file with inputs I need to update this file manually. Right now I only have to update for 5 destinations but as we add more I can see this will become very cumbersome.

I'm attaching an altered version of the file I use and some notes of what I am currently doing, if anyone has any suggestions on how to make this less manual I would really really appreciate it. Thank you guys.