Link to text range in multiple Excel worksheets

[sgreffard]

I've a (for me) tricky problem.

Situation:
- Several people have their own workbooks on a shared network drive, and continually updating text data
- Added complication is that these people can add rows to their text data so the range is not always the same
- One person has to collate all this data/updates into one summary workbook and print off regularly for the VP.

Questions:
- Please help us figure out how to do this?
- There must be a way to link to the text range in each individual worksheet so it updates in the main summary workbook?

I'm unfamiliar with any Excel programming but, with clear and "idiot-proof" instructions am sure can figure it out.

Thanks very much for any help or guidance you can give me... I'm under the gun here ...

Cheers, Susan

[Cheeky Charlie]

Well, without an example it's hard to be precise, but the simple way is simply to put links in - ='[SomeOtherWorkbook.xls]Sheet1'!A1 - replicating the sheets of your individual workbooks in your summary workbook, then run your summary worksheet from the replicas. If you did it this way (there are more clever ways) you will be able to accomodate people rearranging their worksheets manually - if you don't know exactly how people may use their workbooks, I'd recommend this kind of approach over trying to anticipate every possible quirk of your colleagues.

CC