Sorry, I meant the edit menu, not the insert menu. It looks like you
missed out the CTRL+C step. Leaving out the quotes around the sheet name
is OK only as long as your sheet name has no spaces  in it; otherwise
they need to be there.

Just to clarify, once you have the formula throughout your new sheet,
select ALL CELLS and then CTRL+C. While they're all still selected, then
do the Paste Special.