Each week I get a production report for the previous week. Each differently
dated report will have the same type of information on the tabs named exactly
the same.

I insert a Results page and have formulas for numerous fields that reference
the other two worksheets.

Is it possible to Copy my Results worksheet from the previous week's file to
the new week WITHOUT it updating the references (and without having to copy
each individual cell? When I do that now, it changes all my formulas to
reference the previous file. I want the EXACT formula transferred.

For Example:

File 1 --
A5: =SUM(G1:G8)
A6: =SUM(G9:G15)
A7: =SUM(G16:G24)
A8: =SUM(G25:G27)

when I highlight A5:A8 and paste it into file 2 it looks like this

File 2 --
A5: =SUM('[File 1]'!G1:G8)
A6: =SUM('[File 1]'!G9:G15)
A7: =SUM('[File 1]'!G16:G24)
A8: =SUM('[File 1]'!G25:G27)

I want the " '[File 1]'! " to stay off the new file since G1:G27 will
contain the new totals for a different week's production numbers. Currently,
I have to delete that info from every single cell that has a formula.