Linking question

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!

Hello Doc1701,

Welcome to the Forum!

If the workbooks all have the same format and are saved in a single folder, it is quite easy to summarize the information in a master workbook. I have several macros written to do this. Let me know more about how the information is laid out and I can post or modify one the macros for you.

Sincerely,
Leith Ross

Thanks so much! The form is basic order sheet and has input cells for catalog numbers, an item description, price, vendor, and account. The names of the files are highly random (as each user customizes this). But if this info from these fields could be categorized according to account, with each account sheet listing columns for vendor, item, price and description, then having any/all info transferred over. That would be fantastic!

At the moment I'm not sure exactly which cells these are in...I can check/adapt.

Doc