Select the cell on the Summary sheet where you want the data to be displayed.
Type the = symbol and then use the mouse cursor to click the Sheet name where the data is located, then select the exact cell and press Enter. The address in the formula bar should look similar to =SheetName!C5.
Let me know if you need further assistance.
|