Finding and selecting first empty row

Hi guys,

I'm pretty new to this, so this might be a ridiculously simple question, but I've been trying to write a macro that will take a few cells from one sheet, and paste into the first empty row in a master sheet in the same workbook. From other recommendations, this is what I have so far:

Sub SyncNC()
'
' SyncNC Macro
'

'
    ActiveCell.Offset(0, 4).Range("A1:E1").Select
    Selection.Copy
    Sheets("CAPA Index").Select
    Cells(Rows.Count, 1).End(xlUp).Offset(1, 2).Select
    ActiveSheet.Paste

End Sub

The problem is that, well, it doesn't work! I read that other people have used the Cells(Rows.Count, 1).End(xlUp). Offset(1).Select to get the first empty row, but it doesn't seem to be working for me. Can anyone point me in the direction of a solution? It'd be greatly appreciated