ImportRange function in Google Sheets
The ImportRange function in Google Sheets allows users to copy one tab of a spreadsheet - or one range of cells from a single spreadsheet tab - to a new spreadsheet. This is useful when data from one spreadsheet - such as registrations for an event or gradebook grades - need to be manipulated in a second sheet.
Google's support article for the importrange function: http://bit.ly/2SaFSuo