Looking for code to search web based on value and return phone number

Hi,
I was wondering if there is a way to write a VBA code that will take a value from a cell (a name) and search the web to find a phone number. I would want the phone number to be pasted into another cell. I've searched the web but haven't been able to make any of the results work. I have a specific website in mind but in order to get to the phone number page there are multiple clicks required taking me a few pages deep - three to be exact. Any guidance is appreciated!
Thanks,
Jeremy

Joe,
It has the string .../physicians/dr-firstname-lastname-uniqueID. The first page is has a search bar that I can enter the name (or paste it from my cell) and then the state I want to search. The second page comes up with the list of results for that. The third page (if I click on the proper name) brings me to the page where I can now get the phone number.
Does this help? Thanks in advance for the guidance...
Jeremy

Joe,

Thanks. I do not know the unique identifier in advance. Here is what you asked for...

First screen shot at home page. Web address bar contents = http://www.healthgrades.com

image.jpg

First search results page screen shot (normally the search yields only one result though). Web bar contents = http://www.healthgrades.com/provider...SolrCity=false

image.jpg

Final page where phone number is found screen shot. Web address bar contents = http://www.healthgrades.com/provider/john-smith-2y6rf

image.jpg

Thanks,
Jeremy

Has anything happened with this? I'm looking for something very similar, but can take address information from 3 cells (street address, city, zip code) and then can give me back the Zillow and Trulia links for those addresses.

DataToolbar is a good web scraping tool that I use. The free version has full functionality, but you'll only be able to save the first 100 search results.