I am trying to make a spreadsheet for my work and I want to create a drop down list which have to contain "Canceled","ordered","accepted".(I know how to create this drop down list). Now I want the exact thing in another sheet. (This is easy to do using the equal sign). I want to give the user the ability to change the values of these cell from both sheets, in a way that when someone changes the value in Cell A1 in sheet A the value in cell A1 sheet B changes automatically and when someone changes the value in Cell A1 in sheet B the value in cell A1 sheet A changes as well.
How can I do setup this sort of link between two cells?