Web Query - Submitting Data and Capturing Result
 

I have an Excel spreadsheet with a number of queries I want to submit to
Google in column A and I want to get the first result in column B.

I can work out how to get the result from the web page but how do I get the
spreadsheet to automatically submit each query to Google (A1, A2, ... An) and
refresh the data in column B?