How to copy from other spreadsheets

Copying between Google spreadsheets can cause format and #REF! errors
A solution to this problem is to copy the sheet to an existing sheet before copy and pasting.
This video explains the method in more detail