To copy the entire contents to the new sheet:
Select the Target sheet by name using property Sheets->Item("Target")
Convert target to WorkSheet
Wire target's WorkSheet->Range("A1") to specify destination
Use Sheets->Item("Source") to select the source sheet
Convert source to WorkSheet
Wire source to property WorkSheet->UsedRange
Wire to method Range->Copy, wire target range to Desination input
Note that no Paste function is required.