Ok, I did it and something happened, no cigar but I have a revelation. After inputting the "z" line above each pasting row, I noticed that the "SampleResult" page is pulling only from the 1st four lines of the "Data" sheet even though I have input a gazillion. Maybe I am fudging the interpretation of "End(xlUp).Offset(#,0).rowfrom the "z" code?

All I did is change the # from 1, 2,3,and4 like you suggested and I have a header and 3 of the first lines of data. Should I put xlDown? I will try that next.