Dragging SUMPRODUCT formulas downward is not working properly

Hello once again!

We still need help on a solution on how to drag a few of our formulas down ... I've attached a worksheet that has only the tables with the problem. We manually filled in the 2013 formulas. When they are dragged down to fill 2014-2020, the references within the formula change. The only part of the formula that we wan t to change is the "DATE".

We thought we had this problem solved by using a suggestion that involved the INDIRECT command. It caused problems once files were opened and closed ...

I hope someone can come up with a solution. Thank you for helping once again!!