I have a file which I use regularly and which is linked to a file
named "2XDM May '07 Monitoring Summary". This file is updated
everymonth and renamed i.e. "2XDM June '07 Monitoring Summary". The
problem I am having with linking cells to this file is that once
updated and the month changed, I've always had to, either manually
relink or manually type the new month over the old one.This can take a
long time given the volume of data I work with.

What I have In mind is typing the period name i.e. in a cell, say A2
(on the destination file) and then link it with the source file i.e.
file on the shared drive, hoping that every month once I change the
period on the destination drive, the data will authomatically change
to that available for the new month. I have tried this but it wont
work. Below is what I have done!

=+'Q:\directorate_sc\Forecasting Model\Monitoring Templates\Community
Care\2007-08\2XAA_Comm_Services\2XDA_Adults_Services\2XDM\[2XDM May
Monitoring Summary.xls]Consolidate'!$O$73.

Any great ideal will be appreciated.
Thanks,
Ola.