Moving a series of references over a column

I have a worksheet which I'm using to help me predict the outcome of football games using a combination of average scores and average scores allowed, as well a dozen other things to determine the outcome.

I had a simpler, call it the beta version, that I used last year to test if my idea held any water. what I found is that it had a bell curve of accuracy where it started relatively inaccurate but improved towards the middle of the year before it fell off. I considered the later inaccuracy to be the work of too much information dragging the predicted scores down or up so limiting the info to the last 5 inputted games.

So the crux of my problem is now that I'm inputting last year's data into my current system to test the current configuration. I am having the main sheet referencing a row of info for that team specifically and I need the reference block to move over as the season advances. I have the data for up to week six inputted. But now I have to move all the team references over one column to essentially ignore the results of week 1.

So what I need to do is turn =Sum('TeamScores'!C3:G3) too become =Sum('TeamScores'!D3:H3) if I could do that without having to go through each team and each reference and change that for each week it saves me some serious man hours. As well as saves me from the potential of human error.

I considered changing the orientation of the references to be in a row but it comes at the cost of readability. it also doesn't really solve my problem.

I'll give any other info that may need to answer my query if needed.