Some more recording may fit your needs here.

Try recording going to the last row of the *sheet* column A... Or if you
know there are going to be less than 1000 rows, Cell A1500.. Just some cell
past the last row you expect.

Still in the recorder, hit End and then Up Arrow. This should take you to
the last row of your data.

Now move over to Col E.

Now Press Ctrl + Shift + Home.

This should select all the data  you want copied.

Go to the sheet you want to paste into and repeat the going to the last row
of data.

Now move down a row and paste.

*Now* you can stop recording and have a look at the code.

It's not elegant but fairly generic with all those Ends and Homes and stuff.

If you're still stuck then *do* get back and we';; see what can be done.