Connect to Google Docs Spreadsheet as a data source?

I have an online spreadsheet in Google Docs which is continually updated from various sources.

I'd like to use this online document as a data source to populate certain cells in a local master Excel spreadsheet. I would prefer to do this "live" from the online document (rather than constantly saving / exporting to a local copy).

I know that I can use a web table as a data source, but Excel doesn't seem to recognize tables *inside* the web app. I've read that there's an API for this kind of thing but I'm not a programmer and don't know where to begin. Is there a ready-made option to make this happen?

Thanks