For excel experts: I want a two-way link between rows of data on different worksheets. how do i do it?

my organization uses an excel workbook to manage a staff call-out list for a few different sites. different managers can edit the data, but they're only likely to edit it on the page for their own site. Certain staff are on multiple lists, so what I want is to link the cells such that when a cell is edited, all other sheets that the bear that same worker will show the same changes.