Autofill Linking Workbooks that Change Name

[Gone Bananas]

Hi all,

I have tried searching the various threads but have come up with no solutions so here it goes.

I have a Weekly Sales sheet which I include all my daily sales - eg Week 1 contains sales from Sun-Sat. I then transfer this info to a yearly sales sheet where I keep all totals of the weekly sales. I have linked these workbooks together however when I try autofilling the data just repeats. Is there anyway that the link changes from =Weekly Sales 2014\[Week 40 2014.xls]Sales'!$K$62 to for example Weekly Sales 2014\[Week 41 2014.xls]Sales'!$K$62

Any help on this would be appeicated.