Scraping data into an excel sheet from a list of URL

Dear friends I've a List of URL in my excel sheet and I just want to scrap the information associated with the particular URL in different columns.
Kindly suggest or write a VBA code for me so that I can extract the data. I've attached the excel file for your reference. As of now, the list consists of 10 to 12 URLs but I've many more URLs. Kindly help me.

Thanks,