Multiple Sheet Document - Daily To Weekly

I have a multiple sheet document, on the first sheet I have my daily data:

Name
ID#
Ward
TTO
Transport
Transport 2
Date
Time In
Time Out
Time Stayed

ex1
xxxxx
12
xx
Taxi

01/01/12
xx:xx
xx:xx
xx:xx

[Code] ........

This is updated daily and it shows patients that have been through the department, who, when and how long. This is then converted on sheet 2 and shows as:

Date
Number of Patients

01/01/12
2

02/01/12
1

03/01/12
1

My third sheet has a very similar layout to sheet 2 but is weekly, previously i have used the following to find a weekly total:

=SUM('sheet2'!B563:B567)

I now have well over 4000 rows and altering this sum to accommodate for each week is time consuming as sheet 2+ are updated to cover the following 6 months.

Is there a better formula or a way to use the current formula and drag it down to auto fill? Currently trying to auto fill does the following:

=SUM('DAILY ANALYSIS'!B563:B567)
=SUM('DAILY ANALYSIS'!B564:B568)
=SUM('DAILY ANALYSIS'!B565:B569)

I want something like:

=SUM('DAILY ANALYSIS'!B563:B567)
=SUM('DAILY ANALYSIS'!B570:B574)
=SUM('DAILY ANALYSIS'!B577:B581)