Okay, quick update. I've managed to get it to select the sheet. it's now stopping at this line
testRow = Nametest.Cells(20, 2).End(x1Up).Row
I wasn't entirely sure how to code this but what I'm trying to do is. On 'Nametest sheet' fine the next empty row between rows 20-29 then copy the data to there.
Would anyone have any idea how to write this properly?