How to not reference original excel document when copy+pasting sheet references

Hi all,

I'm trying to copy+paste a whole bunch of formulas along the lines of...

=MAX(Sheet2!A1:A5)

from one excel file to another,

but whenever I do,

I get.. a reference to '[Original.xlsm]Sheet2'

instead of Sheet2 in the new document.

How can I set it so that when I copy+paste all the formulas, Sheet2 in the new excel document is referenced?

Thanks!