Hi,

Thanks for pointing me to the indirect() function, it's been very helpful!
Pity that it only works when the other file is open as mentioned, some sheets I want to use it in link to 10+ files. I'll have a closer look at that pull file (Thanks!) but seeing im a n00b when it comes to vb I'll do this with a bit clearer head tomorrow

Thanks for the help!

Cheers, Chris