Cell B12 on sheet 2 can be referred from sheet1 like
ASheet2!B12
BSheet1!B12
CSheet2.B12
DB12 ()
ASheet2!B12
BSheet1!B12
CSheet2.B12
DB12 ()
Related Questions:
Which Excel 2007 feature is used to create a formula that adjusts its cell references relative to the position of the formula in the worksheet?