Hello,
I work with several workbooks and have to print out end of day reports that are compiled with the data from those workbooks. How can i link files where one worksheet will list the data in a column from various workbooks. If i link the cells from the various workbooks to the same cell in the workbook where i want the reports it will not list them it will display the last one entered. I need that information to be listed down in a column. When I enter data in one worksheet it will automatically display that data in my reports worksheet and the next data will come below it. Also i will not be using the workbooks in the same particular order, so when i enter data it will automatically transfer to the reports workbook and it will be listed one after another without skipping around.

I would greatly appreciate it if someone could help me with this. Thank you.

Configuration: Windows XP Internet Explorer 7.0