scraping webpage data modification

Hi,


As i need some expert advise to help me get this code working properly.
1) This code(in attachment notepad) is working fine to scrape data from web page and successfully pasting it to Excel, but ii requires little modification in code so that it will paste data in only one cell, rather than pasting it to whole workbook.

2) Addition modification requires to make a loop through code so that it access the input from Excel(in attachment-Input sheet) and make changes to URL(i noticed in URL that only last word needs to be changed which will be taken from excel file column 1and so on till its find blank)


Any help be much appreciated.
Thanks.