link edits in sub-list to the main list

I would suggest a macro linked to the Worksheet_Change event on the sub-list sheets. This would take the new value, search for a corresponding entry on the main sheet and make the appropriate change.

For example if you ave the following in the first two columns on sheet1 (the main sheet)

Entry 1 Value 1
Entry 2 Value 2
Entry 3 Value 3
Entry 4 Value 4
Entry 5 Value 5
Entry 6 Value 6
Entry 7 Value 7
Entry 8 Value 8
Entry 9 Value 9

and have a sub list on sheet 2

Entry 7 Value 7
Entry 8 Value 8


The following macro in the sheet 2 macro sheet...


Private Sub Worksheet_Change(ByVal Target As Range)
For Each Cell In Target
If Cell.Column = 2 Then
Sheets("Sheet1").Columns(1).Find(Cell.Offset(0, -1), , xlValues, xlWhole).Offset(0, 1) = Cell.Value

End If
Next Cell
End Sub


....will cause any change to a value in the second column of sheet2 to be reflected into the second column of sheet 1