Reference data from other sheets

Within a single spreadsheet, you can replicate data and copy it from one sheet to another.

Get data from other sheets in your spreadsheet

1. On your computer, go to docs.google.com/spreadsheets/.
2. Open or create a sheet.
3. Select a cell.
4. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1!A1 or ='Sheet number two'!B4.

Note: If a sheet name contains spaces or other non-alphanumeric symbols, include single quotes around it (as in the second example).

Get data from other spreadsheets

Important: To reference a cell or range of cells in another spreadsheet, you must use the IMPORTRANGE function. 

To pull data from other spreadsheets, use the IMPORTRANGE function.