Using Multiple Pages in Excel

To Use Multiple Sheets in Excel to Calculate or Reference Data:

• If there is data present on Sheet 1 and you want to reference it on Sheet 2, you can use this formula syntax:
  • =Sheet1!<CELL#> eg: =Sheet1!A1
  • This would get data in Sheet 1, Cell# A1.