I have found that if I put a # in front of the formula to copy
(#=sheet!A1) then remove the # after pasting it keeps the formula
references the same.

Hope this helps,

Dennis