Cross linking of cells in differents sheets with reciprocal syncing

[newbie22922792]

Hello everyone,

I want the cells from different sheets in the attached worksheet to be synced reciprocally. E.g. Table 1 cell K4 is "category", there is a similar cell in table2 K4 "category", and another one in table3 A2 "category". I want them all to be updated in all 3 ways. So that when I enter something in K4, it also appears in cells K4 (Table2) and A3 (Table3). Likewise, if i enter something in cell A2 (Table3) I want the content to appear in the other linked cells and so on.

The next step would be to extend this code to work with other cells, too. E.g. "Subcategroy" across all three sheets and so on.

Thanks a lot in advance to anyone who tries to help me!

The file is located here:

Filebin :: bin j7xm6v26ba1entg8

Upload files and make them available for your friends. Think of it as Pastebin for files. Registration is not required. Large files are supported.

filebin.net

 

[newbie22922792]

If you cant download the file:

I have three sheets (Idea_Outline,Demand,Export) that have some cells that should be filled with identically information. To make it easier I would like to sync some cells with one another. If I enter something in K4(Idea_Outline), it should be visible in K4(Demand) and A2(Export), too. If I enter something in A2(Export) it should be visible in K4 & K4, and vice versa.
So far so good I have this working code (plus codes in sheets Demand & Export but slightly changed)

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("K4") Is Nothing Then Exit Sub
    Application.EnableEvents = False
    Sheets("Demand").Range("K4") = Target
    Sheets("Export").Range("A2") = Target
    Application.EnableEvents = True
End Sub

But: I want to add other pairs of cells. How can I do this ? In the same sheet (Idea_Outline) I have also K5, which should be linked to K5 in Demand and B2 in Export.
I also have other pairs of cells in the same sheets. I only know how to write code for one pair of cells (as posted above). Your help is highly appreciated!