You need the INDIRECT function.
Try =INDIRECT("'[2XDA_Adults_Services "&A1&" Monitoring
Summary.xls]2XDB'!$P$73")

And you don't need the + sign in your formula. [What do you want to add to
what?]
--
David Biddulph

"Ola2B" wrote in message
ups.com...
Can anyone help me solve this problem please. When I type a month in
cell "A1", say for example "August", how can I get it to change the
"July" in the link below to "August".

=+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73.

Many thanks,
Ola.