I am trying to copy and paste from one worksheet to another however, I
am trying to paste all the data to the new worksheet in Column A and
last occupied row.

I can copy all the data that I need fine and I can find the last
occupied row of the destination worksheet but the problem comes with
the pasting.

If I simply do a ".Paste" it will paste the data in the last cell that
I actually clicked on with my mouse (B7, D14, ....) It doesnt matter.
What I need help in determining is how to change the active cell to the
last occupied row of column A of the destination worksheet regardless
of where the last active cell actually is.