How to get update data in master file

Hi. As my title shows that how to get updated data from connected 3 XL workbooks.(files)

1= ODBC connection ( This brings data from a Basis Query) it will updated 1 or max 2 times a day.

2= Manuel input ( It will update after inserting new data, many times a day) Password protected

3= This One is my master file which brings data in 2 different sheets from above mentioned files. Password protected

My problem is started when i want to see latest updates from file 1 & 2 in my Master file then i have to re-open my Master file, Is it any option which fulfill my requirement that i will keep my main file update just by clicking <save> & I will not re-open file at all times ?

I can't have a shared file. & my all these 3 files are in the same folder.

simple Formula used to bring results are =[Book1]Sheet1!$A1


Thanks & regards

Naghman

Please HELP !!!!!!!!!!!

Thanks & regards

Naghman

Hi Naghman

It will be a lot easier for someone to help if you show a sample the files that you will be working with. Make sue all sensitive data is removed!

Regards
Alastair