Pulling data from website

Hi,

Is there a way where I can pull data from google finance through excel?

For example, I type in a ticker symbol of a stock in cell A1 (say F for Ford), and want A3 to show pull over the income statement (http://finance.google.com/finance?fstype=ii&q=F) and A50 to pull over balance sheet (http://finance.google.com/finance?fstype=bi&q=F) .

Thanks.

Thanks Mudraker. That was very helpful.

I'm pretty new to this macro business, and for the most part, I think I understand what was written down. Some follow up questions if I may:

Going back to the ford income statement example, (http://finance.google.com/finance?fstype=ii&q=F), google allows the user to switch between Quarterly data and Annual data. However, the website address remains the same.

If I wanted to tell excel to grab the annual data as opposed to the quarterly data, which part of the macro do I code this in? Is it related to the web table?

On websites like these, where you can switch between data without the website address changing, how do tell excel which link to pull the data from.

Thanks again.