Have you tried the "get data/from file" from the data tab?
load the data from a workbook, set the amount of time it pulls data from a workbook.
it will pull selected cells data from a closed or open workbook and input it into a field on a data sheet.
which you can then =cell to display the data wherever you'd like.
hope thats no to confusing?