Copy sheet from another workbook - runtime error 1004

Hi,
I am trying to copy a whole sheet from a workbook into another. My current code is presented below. When I run this I get 'Runtime error '1004'. The copy method in the Worksheet class failed.' Any ideas or suggestions?
Cheers

Please Login or Register  to view this content.

I'd prefer:

Please Login or Register  to view this content.

You'd better not give the same name to a sheet and a workbook.