Hi everyone,

I've been reading around several posts but not yet able to find the solution for what I'm looking for.

I have a worksheet called 'Index' where I am storing all worksheet names.

I am interested in bulk creating a webquery in some of these worksheets. More specifically every worksheet listed in 'Index' from A9 down inclusive.

Then, I would like for each webquery, the system would read the URL string from cell B7 on each worksheet and build the webquery on cell D13.

Can anyone help me doing this please? I'm trying to collate steps from different posts but getting a few errors. If someone can help me out with a fresh code, this would be wonderful.

Thank you in advance for any help!