Hi guys!
I have two excel sheets- a new one and an old one.
In the new one, I have developed a new tab. I want to copy this tab to the old one. I do it, but the formulas look like:

=SUMIFS('C:\Users\kaligad\Desktop\[new_file.xlsb]Sellout RAW'!$N:$N,
'C:\Users\kaligad\Desktop\[new_file.xlsb]Sellout RAW'!$E:$E,'HW | Benchmark'!$B$115,
'C:\Users\kaligad\Desktop\[new_file.xlsb]Sellout RAW'!$H:$H,'HW | Benchmark'!G$116,
'C:\Users\kaligad\Desktop\[new_file.xlsb]Sellout RAW'!$C:$C,'HW | Benchmark'!$C120)                                                         /1000
And these references are killing my efforts!
Any ideas what to do, so the formulas in the old tab look like this, when they are copied:

=SUMIFS(Sellout RAW'!$N:$N,
Sellout RAW'!$E:$E,'HW | Benchmark'!$B$115,
Sellout RAW'!$H:$H,'HW | Benchmark'!G$116,
Sellout RAW'!$C:$C,'HW | Benchmark'!$C120)                                                         /1000

A possible solution is to use CTRL + H and to replace:
C:\Users\kaligad\Desktop\[new_file.xlsb]
with:
"".

But there should be a normal solution... Any ideas?