I guess another (maybe simpler) way to put it would be:

Everything that happens on this sheet (the individual's sheet)
C:\Documents and Settings\Administrator\Desktop\[j.doe.xls]Sheet1


To be copied to this sheet (my master sheet)
C:\Documents and
Settings\Administrator\Desktop\[master.request.xls]Sheet3


and vice versa.

Thanx