Range("A1").End(xlDown).Copy Worksheets("ABC").Range("A1").End(xlDown).Offset(1, 0)
Range("A1048576").End(xlUp).Copy Worksheets("ABC").Range("A1048576").End(xlUp).Offset(1, 0)
Range(Range("A1"), Range("A1048576").End(xlUp)).Copy _
Worksheets("ABC").Range("A1048576").End(xlUp).Offset(1, 0)