Copying data to a changing spreadsheet

I would like to copy a row of data, go to another sheet and paste it at the bottom of several rows of data. The rows of data will change each time I do this, so I can’t use an absolute cell value to paste to. In older versions I could write the macro to go to the top row of data, do {END}{DOWN} {DOWN},then paste. How do I do this inside a macro. Thanks.