I'm trying to create a summary sheet showing the total time spent, on a
weekly basis, at varoius sites. The summary sheet is the same layout and
format as the timesheets, so that the totals of all sheets for cell C14 is
shown in cell C14 on the summary sheet.

So for the sites Cathcart, Howwood, KyleofLochalsh, Lanark and Tain and date
151206 I have the following function.

=SUM('P:\\Time Booked\[CathcartTime.xls]151206'!$C$14,'P:\\Time
Booked\[HowwoodTime.xls]151206'!$C$14,'P:\\Time
Booked\[KyleofLochalshTime.xls]151206'!$C$14,'P:\\Time
Booked\[LanarkTime.xls]151206'!$C$14,'P:\\Time
Booked\[TainTime.xls]151206'!$C$14)

The workbooks are named by Site and the Worksheets within each book are
named by Week i.e.
Workbooks: CathcartTime.xls, HowoodTime.xls etc.
Worksheets: 221206, 050107, etc

The above function totals the time from the file/sheet/cells stated, but
when I try to copy this to other cells it doesn't update the reference to
reflect, for example, the totals for cell C15.
Is there an easy way to update this to reflect totals for cells in the range
C14 to T23?
Is there a way to update this to reflect time in the worksheets dated
221206, 050107, 120107, 190107 and 260107?

Regards
Dylan Dawson
Scotland