Hi

I have some tables in various xl files, call the files a,b and c. I want to import all these into a single xl file called e. If changes are made to a,b or c I want it to automatically update e.

I have used the import function in d but if I change a,b or c to see the change I have to select the data in d and press refresh. Furthermore when I refresh d i have to have files a,b and c open otherwise it says connection lossed and is unable to refresh the data.

Can someone explain to me in simple terms what I have to do in order to get the data automatically updated without having to always keep the files open and refreshing the data.

Thank you in advance.