Not 100% sure what you mean by automatically transferring, you can go into
your 2nd sheet and double click the cell type = and then go to the 1st sheet
and click on the cell you want to update from. you should end up with
something that looks like this in the 2nd sheet cell =Sheet1!A1 This cell
will then display whatever is in A1 and will change as you change the value
of A1 in sheet 1
