Hello,
A1 Sheet2 is linked to A1 sheet1 so that user types in (abc123) a1
sheet1 and A1 sheet2 is updated, what I would like to know can I also
somehow enter BBB 444 on sheet3 A1 and have it replace ABC123 on
sheet1 A1 and have it update A1 sheet2 with BBB 444.

Hope that is explained well enough


thanks