Date range with cell totals to another sheet

Hi,

Trying to figure out an easy way to take our sales totals from last year and have then input into a cell pending the month that we are in. So for instance, we are currently in January, so I need January 16 to show in the is cell and have January 16 to show into a different cell. Now we are a couple days away from February then I would like it to change to the February numbers.

I have added 2 excel sheets for demo. The "2017 Goal Mock" is that data that I would like to pull over to the "Goal Sheet Mock". I have "X's" marked on the Goal where I want the data to be displayed depending on which month it is, ie. February C6 would show $104,000 on the "Goal Sheet" J4 and N6 would show on the "Goal Sheet" J6. I would like this happen automatically.

Not sure if this is possible at all.

Thanks for you help in advance.

Dan