Hello!

I am trying to update the excel system for my work, learning as I go.
We basically have a main client spreadsheet that lists name, address, phone number, etc in columns.
I have made a copy of that worksheet in order to use just for entering payment information, with just the columns needed for that.
We sometimes update contact info when we process payments.
I want to link, say, the phone number column from the main worksheet (Contracts, column H), to the phone number column in Payments (column E), so that if I update the phone number in one of the H cells in Contracts, it changes that corresponding cell in Payments to match that, and vice versa. A two way link.
I know that there is a way to link one way with just formulas, but from what I understand, VBA is the only way to create that link both ways.

Help appreciated!
Raia