referencing the items in spreadsheet between different sheets

I am working with 2 sheets in a single spreadsheet and I want to link the items of cells of first sheet to the cells of second sheet so that when I make any change in a cell in one of the sheets the same change should take place in another sheet in its linked cell.

I followed what is being sugg开发者_如何学Cested here Linking cells in same Excel spreadsheet but it didn't work. Thank you.

If the sheet you are making changes to is Sheet2, in sheet1 just use something like =Sheet2!A1 and the cell will directly show whatever is in the cell A1 in sheet2, etc.

If both sheets need hard coded values then you'll need to do something more complicated, like an event in VBA.