Can you copy & paste cells across worksheets and preserve reference to worksheet?

[New Daddy]

Can you copy & paste cells across worksheets and preserve reference to worksheet?

I have multiple analysis across multiple worksheets, but want to bring them all together and create a single big tabulation. But when I copy & paste the tables from one worksheet to another, I get an error because some formulas are now off, unless they refer to their original worksheet. Is there any way to convert the formulas so as to include a reference to the original worksheet when I copy & paste data from one worksheet to another?