Is there a way to which I can have a master sheet in one folder and have
multiple files imputing information into the master sheet? Here is the trick
I want to know. Can the master be updated by these files with out myself
transferring the data?
and to that can the files be located in different areas (ie. master is
located in C: drive, and the other files be in D: drive on some one elses
computer). Does that make sense?