You can do this manually.Have the two files open and put "=" into a cell... Then go to A1 of theother sheet and press return.A reference will be inserted.