I got it to a point. Here's the code I'm using.
Dim wk As Worksheet
Dim wkD As Worksheet
Set wkD = Worksheets("tst")
Set wk = ActiveSheet
wkD.Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
BUT, when I was doing some testing and copied a 3rd sheet I get this "The name "Direction" already exists. Click Yes to use that version of the name, or click No to rename the version of "Direction" you're moving or copying"
. If I hit yes it then says "The name "H" already exists. Click yes to use that version of the name, or click No to rename the version of "H" you're moving or copying". Hitting yes again says the same thing but it's "Location" instead of "H", then same but with "V". It does still work if I hit yes 4 times. Would you be able to explain what it's trying to tell me?