search column for text within a range of cells then copy cell to separate sheet

Hello,

I have a spreadsheet with two worksheets. In the first worksheet, in the first column, I have text but not in every cell of that column. my cell range in that A column is A5 to A244. I would like to search that column starting at cell A5 and if the cell is found to be blank then go search the next cell and so on and so on until i find text. when i find text i would like that text to be copied to a separate worksheet starting in the first column, first row cell a1. then i would like to go back and keep searching down until A244 on the worksheet and repeat this process over and over so that all text found is placed in my second worksheet column "A' so that cells a1,a2,a3,a4,a5,a6, etc. are filled. Thanks for any assistance provided.

Thanks for the suggestion ChemistB. My spreadsheet is for a fantasy sports draft and I was hoping to automate it. The spreadsheet has more to it but I wanted to simplify my request so as not to confuse or over complicate things. I figure i need some sort of structure using a loop, ifthen, istext isblank, etc. to finish up the spreadsheet and complete the tasks i'd like it to perform. I am mostly familiar with ifthen stuff and that is mostly what my spreadsheet currently involves. What I'm gonna do is pop around some more in the beginners threads and try to teach myself to come up with a macro and next year ill have a more powerful spreadsheet for my fantasy sports drafts... or cough up the $$ for a online store bought one. Thanks for taking a few quick secs to suggest a solution to me.