Is there a method to connect 2 or more cells from different worksheets together in such a way that when any of the cells are changed, the rest automatically update. For example, I have three worksheets, sht1, sht2, sht3. Cell A1 of sht1 should be connected to cell A1 of Sht 2 and cell A1 of Sht3, If I make a change to cell A1 of any of the three worksheets, that change will be automatically shown in Cell A1 of the other two worksheets.

There is no formula that works both directions. This also sounds chaotic. A good sheet design would be to have ONE main sheet where you input data, and the other sheets use formulas to present subsets of the larger data.

You can start the long and funfilled journey down the path of "programming" and start to develop macros which can be programmed to do pretty much anything, including this.