i want to show values of cell 1 from sheet 1 in the cell 2 from sheet 2 without writing any formula in the cell 2 

for example : if the g30 cell is =sum(g1:g29) and i want the value to be shown in b10 in sheet 2 , i have to write (=sheet1!g30) in cell b10 to see the value of g30 in b10 , how can see the value of g30 in b10 without writing any formula in b10.

​i want to show values of cell 1 from sheet 1 in the cell 2 from sheet 2 without writing any formula in the cell 2 for example : if the g30 cell is =sum(g1:g29) and i want the value to be shown in b10 in sheet 2 , i have to write (=sheet1!g30) in cell b10 to see the value of g30 in b10 , how can see the value of g30 in b10 without writing any formula in b10.  Read More

​