Editing cell in multiple tab WITHOUT grouping

[cowboysnut]

Is there a way to edit cell M2 on Sheet1 where it updates on Sheet2 as well, but if I edit it on Sheet2 it updates it on Sheet1 WITHOUT grouping or selecting the tabs? Can I somehow specify that a certain cell is live and active through all sheets?

I currently have an equation on all sheets that ties back to my home indexing sheet and I update it there, but I would like to cut out the step of jumping back to the home sheet if I can.

 

[Fluff]

The code that Jaafar supplied in post#7 works for me.
Did you change Sheet3 to Index?
Also, did you put the code in the ThisWorkbook module?

 

[cowboysnut]

The code that Jaafar supplied in post#7 works for me.
Did you change Sheet3 to Index?
Also, did you put the code in the ThisWorkbook module?

ThisWorkbook was my failure. Thank you so much! Excellent code Jaafar and thanks for straightening me out Fluff. That's spectacular.