Loop web data into new column on same sheet (Code included)

How can I modify this so it outputs the data to a new column on just 1 sheet? Right now, it's creating new sheets for each link. Would like to output to column 1, 2, 3 , 4, 5, etc...

It's currently outputting to column 1 and 2 on each new sheet, which is fine. I just don't want to have 1000 sheets when I run the macro with 1000 links.

Please Login or Register  to view this content.