Copy formula with source destination

Hi

I am sure this is simple but cant get me head around it (tried paste & paste link).. I am wanting to copy formulas in file (A) to file (B) with data source linked in the file (A). All i want is when i copy the formulas to file (B) sheet 2 and it should retain the original path say H:\excel\file A[sheet1]$G$1+....xls and source from which the data is being used.

please could anyone help.

thanks

tek9step