VBA code required for copying rows from one tab to another

[salvo69]

HI there

I am struggling to complete a code for the following:

Highlight all active rows which include data on one tab on a spreadsheet and copied across to another tab on the next available row. This is on the same spreadsheet

Thanks