Formula to move x columns along

Good Afternoon

I am setting up a sheet for next year and it looks at weekly data.

The first formula I have in place in column A is this

Formula:

='[Forecast 2014.xlsx]Daily Actual 2014'!C5

I want column B to be

Formula:

='[Forecast 2014.xlsx]Daily Actual 2014'!J5

And then column C to be

Formula:

='[Forecast 2014.xlsx]Daily Actual 2014'!Q5

So basically I need the formula to look at the row 7 columns on from the last but I have to do this for the whole year and that will take ages!!!!

Is there any way I can do this or would it have to be a macro