I haven't done much page/cell linking with Excel but I'm hoping that there is a relatively easy way to have one Excel file automatically update and compile information from multiple randomly named other files. Perhaps the only criterion is that they be dumped into the same folder? Can anyone tell me if this is possible to set up? I've got a ton of information coming in from many people using the same form excel file and i'd like to easily compile all info from these docs into one.

Thanks!