Select sheet1 then CTRL + Click on sheet2.
This groups them and what you do to one will be done to the other.
Or, without grouping the sheets, in sheet2 in a cell enter =sheet1!A1
What you enter in A1 of sheet1 will be returned to the cell in sheet2
Gord Dibben MS Excel MVP
