k...here's how to do it:


in the cell you want the info displayed, you have to type =[sheet1!]$A$1

replace "sheet1" with the tab you are drawing your info from, make sure to include the !, also don't use the [ ], and replace A1 with the cell number its coming from on the first sheet.



so for example I want to draw the info from cell C7 from the "Assumptions" tab, it'll look like this:

=Assumptions!$C$7