I strongly recommend trying to use fewer sheets but use tools lke filtering and pivot tables to display the data different ways.
But to create a formula:
- Click in the cell that you wish displayed a value from the original sheet.
- Type an equal sign
- Navigate to and click on the cell that contains the value
- Press enter
Alternatively:
- Select the cell that contains the value
- Copy
- Navigate to and click on the cell that should display this value
- Use the drop-down on the Paste button to choose Paste Link
Pay close attention to the Formula bar. (the long white box just below the Ribbon). It will show you the true contents of the active cell. (You will be able to view formulas, not just results.)