how can i show value of one cell in another cell without writing the formula

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 b...