I am creating a simple spreadsheet which pulls data from another. The first
(diary) has the names of operatives and the job numbers where they are
working, each week of the year is represented by a worksheet ie: week 17,
week 18 etc etc. The second (timesheet) takes the job numbers and enters them
onto a time sheet. This I can do by using (='[Diary.xls]Week 17'!$B$2) which
is pretty straight forward. The problem I have is in the second (timesheet)
spreadsheet, is there any way I can copy the second (timesheet) spreadsheet
increasing the week number ie: (='[Diary.xls]Week 18'!$B$2)
At the moment when I copy the worksheet the same formula appears and I have
to manually change it over and over again.

I hope this makes sense

Any help would be greatly appreciated.