Macro to Copy and Paste to new sheet

Hello,

Im not great with excel macros and VBA so bear with me.

I want to create a macro that will Copy and then paste the current highlighted selection onto a new sheet.

I have this code -

Sub CopySelection()


Selection.Copy Sheets("Approved & Completed").Range(Selection.Address)


End Sub

Which copies and pastes the selection into the same range on the new sheet (Approved & Completed)

Problem is once this have been done the user then deletes this record from the first sheet and new info is put in it's place, which, when copied across overrites what is currently there.

What i want is a macro that copies the selection to the new sheet into the next empty row.

Sorry if this is confusing, thanks in advance.