Is there a way to duplicate what I input in one workbook to another workbook in the same sheet?

I have a big sheet for my leads and clients. It has many workbooks depending on countries of the accounts (USA accounts, UK accounts, Dubai accounts, etc..)

In each of those Accounts workbooks, there's a column called "Contact" where I have the names of all my contacts of those accounts.

However I want 1 workbook that's only for contact details (name, email, number, company).

All the ACCOUNTS workbooks ONLY have contact name (let's say under column B) but all other columns in those workbooks are for other purposes regarding that account.

Is it possible that whenever I add a new name under the contact name (Column B) in all workbooks, that that name is instantly added to that LAST workbook which is only for clients (let's say also column b or whatever column I choose)?

I'm sorry if this is too compmlicated but I've been surprised before by Excel's capabilities and Nerds' knowledge thereof XD

Much appreciated