VBA Data Connection Help

[Confidentjohn]

Hello All

I have had this working before but am stuck and can't figure out how to sort this issue.

I want to pull data in using a webquery and VBA

I have a worksheet that i populate with URLs, i want to grab the URL from this sheet download the data and place the results in a separate sheet.

Ultimately there will be multiple URLs on the URL sheet and I will want to place the data on a specific sheet for each.

Can someone help me out with the initial part of the vba and I can figure out the rest.

Cheers

John