Master Spreadhseet retrieves data from children automatically

[Tommy]

Hallo,

I currently have 10 children spreadsheets that update their data every
afternoon. I want to create a masterspreadsheet that retrieves CERTAIN
COLUMNS of each children spreadsheet. If the data of the children spreadsheet
changes, I obviously would like that change to be also updated automatically
in my master spreadsheet. How do I implement that most elegantly?

 

[Tommy]

There are no formulas involved in the children spreadsheet. The children
spreadsheet just has time series data, that it receives from Datastream. The
masterspreadsheet should just be able to link to these data as they get
updated every day.