extracting information from one sheet to another

[jlutz]

Hi Guys,
I have quite a few worksheets that have information (links to websites) that I'm trying to gather onto one worksheet. There aren't any tables. The information begins in column A (but the information goes beyond column A) Is this possible?

 

[VoG]

This may help http://msdn.microsoft.com/en-us/library/cc793964.aspx

 

[jlutz]

Thank you for that link but I'm not seeing anything that will execute what I am looking for.