Transferring Data from Multipage Userform to Separate, Subsequent Rows in Excel

[maraecole3]

Progress, but I got a object error and a overflow error when xlDown. I also am trying to do negative offsets since it should be starting from the bottom. When I tried the initial variations of what you posted, I was able to see that it is copying over to sample result, it is just not copying the correct rows. It is taking my first 4 rows all the time and not any of the later entries. I am trying to Google how to get around an overflow. It is highlighting this line:

z = ThisWorkbook.Sheets("SampleResult").Cells(Rows.count, 1).End(xlDown).Offset(-4, 0).row

I was hoping this line will say, "run to the bottom of the entries in "A" and back it up 4 rows and proceed with that". I hope I am interpreting this correctly. :/