Multiple Web Queries

Hi

I would appreciate any help on the following issue I'm having.

I need to pull data from an internal company phonebook and parse that data in Excel. Unfortunately I can't provide any links as they wouldn't work anyway. I will be including the .igy and workbook to show what I've been able to accomplish thus far.

What I would like happen:
1. Add list of ID #s to spreadsheet and automatically run a web query against the web phonebook and pull the data.
2. Sort this data from the current single column (multiple rows) to a single row (multiple columns)
3. Append new data to next row, not overwrite the first row.
4. Automatically have all of the above done by running a macro or VBA.

My apologies if I'm not explaining this properly.

What I have done:
1. Add list of ID #s to spreadsheet (Column A) but can only run one query (phonebook2.txt, renamed from phonebook2.igy) at a time which posts the data to column B.
2. Used an INDEX formula to sort data from column B to Column C, D, E, etc...
=INDEX($B:$B, COLUMN()+((ROW()-2)*8))

Attached are the files, any help is appreciated!