OFFSET troubles

Hi guys

Doing a sample cash forecast but struggling with trying to consolidate daily totals into weekly. So template is basically has hard-coded manual entries into "ccy daily f'cast" tab, then consolidated into £ into the "Cons Daily F'Cast" tab. Now want to sum up the "Cons Daily F'Cast" into a weekly view into the "Cons Weekly F'Cast" but I'm not sure what I'm doing wrong with OFFSET way of doing it as that is what I've used before from this forum, though can't get it to work here :/

=SUM(OFFSET('Cons Daily F''Cast'!$C6,0,(COLUMN(D5)-COLUMN('Cons Weekly F''Cast'!C5))*5):OFFSET('Cons Daily F''Cast'!$G6,0,(COLUMN(D5)-COLUMN('Cons Weekly F''Cast'!$C5))*5))

Will also want to consolidate it further into monthly view as well on the first tab but clearly don't know what I'm doing! Thanks again