Syncronize list box value on multiple worksheets - if one changes, they all change

[Rx_]

Used the standard Data Validation option to create an in-cell drop-down List.
There are 3 user Worksheets.
Each of the 3 Worksheets have the same in-cell drop-down list. They all use the same Named Range criteria for the list.

If the user is on Worksheet 2 and changes the selection from 1 to 2:
- The same result 2 needs to be updated on Worksheet 1 and Worksheet 3.
- The same for the other two. So any change in a drop-down list would be syncronized.

Preference would be not to use vba code.
Or, would be open to somehow showing one common linked cell header on the top of the three worksheets.
Somewhat like a header/detail in a report.

I can't seem to wrap my head around this request.

 

[Rx_]

If someone has a better idea, please let me know.
I came up with a way to solve this with VBA.
An attached workbook for downloading with the code is at the bottom of a post located at:
Drop down lists to change all data - Access World Forums
Drop down lists to change all data - Access World Forums

If someone can suggest a better way, please let me know.
- regards