Select a varying range of text and paste into a cell
 

Right I have some data from a testing machine that I need sort into something
that can be easily read. What I need to do is setup some kind of macro to
copy multiple sections of text that starts as "Test Number" and finishes
"User 0000000000" and paste it into a cell, and to keep taking these sections
of text till it reaches the line "END OF DATA".