External linking to an entire worksheet

[JoelBU]

Hello everybody,

I have a number of Excel workbooks that use the same data in different ways. I would like to use a separate file for this data and have the other workbooks update automatically. The complicated part is that the number of data points changes and I would like to be able to see the data--properly formatted--in each of the workbooks.

Ideally I would expand this concept to multiple data files. The situation would look something like this:

INPUT
--------
File 1 - Data 1
File 2 - Data 2
File 3 - Data 3

"REPORT"
-------------------------------
File 5 - Data 2, Data 3
File 4 - Data 1, Data 2
File 6 - Data 1, Data 2, Data 3

I would like to enter my lab data into each of the "input" files and see it--as I said, complete and properly formatted--in each of the "report" files.

Any advice would be greatly appreciated. I am open to any strategy that allows me to enter data from lab experiments once and then see in multiple places.

Thanks!

--Joel--