Is there a way to have two different sheets work in one document?

[Guest]

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?

 

[ANDRE.TASSEL]

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?

Something like this ?

='P:\TEMP\[myfile.xls]sheet1'!$C$6

This is entered on your PC, assuming P\TEMP\myfile.xls is on the
network.