I think I have stumbled on the $ - formatting fix.

After I do the ctrl+v and then paste links, I go to tools/options and remove the zero vales check and then do an undo which returns the merged cells as they were and also removes the accounting formatting $ - symbol.

Not sure why but works for me.

Still not sure how to get the sheet names across?

Regards,
JB