Web Query w/parameters

Excel Programming Help,
thank you in advance for any help that you can provide. I have a excel sheet with contact data in rows which I would like to input into a web query string. I have created a web query that asks for the search string parameters and this works. It then dumps all the text to A1 of sheet 2. I am trying to search the results of the web query for a phone number in the format "(???) ???-????". I then want to take that number and paste it the phone number column for that contact. Following this I want to run the query again with the next row of contact/parameter information. I figured the web query results could be overwritten or cleared on Sheet2, since I am only interested in the Phone number.
In some other posts I found a web query macro that reads parameters every 64th row but I am not sure how to adapt for my use and add the phone number pasting and subsequent clearing of previous web query results.

I have attached a truncated version of my spreadsheet for reference.
Cell D2 is the cell I would paste the resulting phone number into, AH2,AI2,AQ2,AR2,AS2 are input parameters for the search string and AZ2 is a complete search string, should it be needed.

I am getting a bit overwhelmed with the macro writing, so any help would be appreciated, even if I could somehow piece this together with various bits of code already written.

Again, thanks in advance!

Steve