Copy same formulas to new workbook

I have 2 workbooks that are just about identical. Same worksheet names, etc. I have about 20 formulas/cell references I want to copy from one workbook to another.
I thought if I did it using ctrl ~, everything would copy

I want the new workbook to just show this formula
=SUMIFS(Actuals!H:H,Actuals!E:E,N11,Actuals!A:A,N2,Actuals!C:C,P2,Actuals!G:G,Q2)

But I'm getting this:
=SUMIFS('[Z005 N60025 Program DATE MOD Xb01.xlsx]Actuals'!H:H,'['[Z005 N60025 Program DATE MOD Xb01.xlsx]Actuals'

What's the quickest way to do this? The only way i know of is copying each formula instead notepad and pasting into the worksheet. Looking for something quicker.

But I'm getting this:
=SUMIFS('[Z005 N60025 Program DATE MOD Xb01.xlsx]Actuals'!H:H,'['[Z005 N60025 Program DATE MOD Xb01.xlsx]Actuals'

You can copy the formulae and then do a global Find & Replace:

Find: [Z005 N60025 Program DATE MOD Xb01.xlsx]
Replace: (nothing)