Sub CopyAndPaste()
Dim wksSource1 As Worksheet
Dim wksSource2 As Worksheet
Dim wksDestination As Worksheet
Dim lngLastRow1 As Long
Dim lngLastRow2 As Long
Dim lngPasteRow As Long
Dim rngSource1 As Range
Dim rngSource2 As Range
Set wksSource1 = ThisWorkbook.Worksheets("Sheet1") ' Set 1st source sheet (to copy from)
Set wksSource2 = ThisWorkbook.Worksheets("Sheet2") ' Set 2nd source sheet (to copy from)
Set wksDestination = ThisWorkbook.Worksheets("Sheet3") ' Set destination sheet (to paste into)
' Find last row of data in each source sheet
lngLastRow1 = wksSource1.Cells(wksSource1.Rows.Count, "A").End(xlUp).Row
lngLastRow2 = wksSource2.Cells(wksSource2.Rows.Count, "C").End(xlUp).Row
' Set reference to each source range
Set rngSource1 = wksSource1.Range("A1:A" & lngLastRow1)
Set rngSource2 = wksSource2.Range("C1:C" & lngLastRow2)
' Copy 1st source range
' Paste into row 1 of destination sheet
lngPasteRow = 1
rngSource1.Copy Destination:=wksDestination.Cells(lngPasteRow, "A")
' Copy 2nd source range
' Paste into next row of destination sheet
lngPasteRow = rngSource1.Count + 1
rngSource2.Copy Destination:=wksDestination.Cells(lngPasteRow, "A")
End Sub