I have a list of businesses, and I want to add their website into my spreadsheet. Rather than searching for each one individually, I was hoping I could set up a macro to do it for me. So, my spreadsheet looks something like this:

A B C D E
1 Business Name City State Google this concatenated phrase URL
2 ABC123 Helicopters Los Angeles California ABC123 Helicopters in Los Angeles California
3 Lizzard Food Store Chicago Illinois Lizzard Food Store in Chicago Illinois

I want to basically have a macro search online (via google or bing) for the phrase in the D column and return the first search result's URL in the E column. Any thoughts?