Google added a new function called “importRange” into Google Spreadsheets, that’ll import your saved data from a Google Docs spreadsheet into another spreadsheet. Say, you’ve a spreadsheet with following URL:
….just define a range to make referring to this data easier named “PeopleAges” . In your second spreadsheet, edit a cell and copy the key of above URL as first parameter. The second parameter will be the range name:
….now hit return on the above formula, the second spreadsheet will briefly display a “loading” message and then shows the age data from the other spreadsheet.
Source:→ Google Blogoscoped