Range.Copy (Excel)

Copies the range to the specified range or to the Clipboard.

Copy (Destination)

Destination: Specifies the new range to which the specified range will be copied. If this argument is omitted, Microsoft Excel copies the range to the Clipboard.

Worksheets("Sheet1").Range("A1:D4").Copy _ 
    destination:=Worksheets("Sheet2").Range("E5")