Hi dba,
I assume that when you refer to "same cell" you do not mean that if you edit B4 on the first sheet B4 gets modified on all the other sheets, but instead you mean something like the cells in column B on the other sheets whose values in column A correspond to A4 on the first sheet are the ones that get modified. If this is the case, you could do it by linking every value on the other sheets back to the first sheet (presuming that they are just different row number orderings of the same data). But it would probably be easiest to write a macro to do a lookup of the record being edited in all the other sheets. Such a macro could be triggered automatically when you enter data on the first sheet via the worksheet Change event.
Damon
