Screencast showing how to automatically pull data from 1 Google Spreadsheet to another
Screencast showing how to automatically pull data from 1 Google Spreadsheet to another - Please note that since creating this screencast the way Google creates the URL seems to have changed slightly - follow the instructions above, but the key that you are looking for will be the part of the URL between "key=" and "#gid=0"