Adapt web query based on cell data

[claytorm]

Hi,

This is a multi-part question - I'd appreciate help with any of it! Workbook attached.

I have a workbook contains a 'Master' sheet with a number of names in Col A (c. 300 names)

1.) I want to create a new sheet for each entry, the new sheets deriving their name from each entry in Col A of Master.

2.) In each of these sheets I want to set up a web query similar to the web query currently embedded in the "888-LN" sheet. Each of these web queries are identical apart from a change in the URL. The characters preceding "-LN" form the variable in the web query. "http://www.advfn.com/p.php?pid=financials&btn=s_ok&symbol=LSE%3A888&s_ok=OK".

3.) Finally, in each sheet I want to insert a column to the left of the data returned by the web query. The first row of this column should contain the heading "Symbol", and each row where data is returned by the web query should contain the same name as the sheet name. As shown in the "888-LN (final)" sheet.

Any help, very gratefully received.

Bert