this is my formula...

=IF(ISNUMBER('[REWORK 02-05-05.xls]%'!$B$7),'[REWORK
02-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 03-05-05.xls]%'!$B$7),'[REWORK
03-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 04-05-05.xls]%'!$B$7),'[REWORK
04-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 05-05-05.xls]%'!$B$7),'[REWORK
05-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 06-05-05.xls]%'!$B$7),'[REWORK
06-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 07-05-05.xls]%'!$B$7),'[REWORK
07-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 08-05-05.xls]%'!$B$7),'[REWORK
08-05-05.xls]%'!$B$7)


how can i repeat this formula but repalcing '7' with '8','9' and so on with
out having to manually edit it?
Is it also possible to to the same for the dates for the following weeks?
otherwise i have a lot og typing to do! (52 weeks and 365 sheets)

Cheers
Mark
--
Total Office Novice