Macro To Transfer Data From One Sheet To Another In Same Workbook

I am now on my third attempt to perform a fairly basic task of transferring data keyed to a separate log. I originally started with a user form transferring to a separate work book however this was not practical. I then had a values keyed into a worksheet being transferred to a separate workbook however network issues mean this data keeps being lost.

I am now trying to simply transfer data keyed in one worksheet to the next available line in a different worksheet in the same workbook.

Here is my code that I have chopped and mashed together from my previous versions.

The sheet the data is be keyed into is called Key and the sheet where the data is to be sent is called log. I would also like the values in the Key sheet to cleared once transferred:

Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Log")
iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
ws.Cells(iRow, 1).Value = Key.Range("E7")
Key.Range("e7").Value=""""
End Sub