Yes , that is done by giving the address of source excel file in the destination file , as following:
e.g.
='\\192.168.0.1\Software (D)\[book1.xls]abc1'!$A$1
Here
“\\192.168.0.1” is the Another Computer IP Address.
“\Software (D)” is the D Driver of the H.D.D. .
“\[book1.xls]” is the file name.
”abc1” is the name of the Sheet name of Source File.
“$A$1” A is the Column Address & 1 is the Row Address.
Advantage
We can give the Network path also in the Excel Cell.
We can give more than one address in a single file from different files.
Disadvantage
It is Possible that the Cell Value can not Update when Destination file is open.
Any Other Query You Can Mail Me :- a.suchariya@gmail.com