Hi,

Is it possible to have links to another file based on a variable factor
selected in the main sheet?

For example, the main file is currently linking to a JuneUK.xls file as I'm
displaying June data. If I were to change the main file to show July data (by
dropdown box and Indirect formula) is it then possible for the links to
realise that they need to be adjusted to link to a JulyUK.xls file?

Hope this is clear. Let me know if not.

Cheers!