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 nonalphanumeric symbols, include single quotes around it (as in the second example). Get data from other spreadsheets. To pull data from other spreadsheets, use