Multiple Spreadsheets in Excel
USE one sheets value on another sheet
In the original sheet, you have the value that is entered or calculated.
In the destination sheet, you want to use it. So type = in the destination sheet and then go in the original sheet and click on the value you want to use, then press ENTER.