Macro to Move Data with name to another sheet if name is moved

[hajiali]

Hello all I have a Master Sheet that has Names in column A and each Name has its own Sheet and Data ex:

A1	BOB
A2	JOHN
A3	PETER
A4	SMITH
A5	LIZ
A6	TOM

<tbody>
</tbody>

I have A sheet named "1" in B1= BOB, Sheet named "2" B1= JOHN, Sheet named "3" B1= PETER
Sheet named "4" B1= SMITH etc... with B1 of each sheet link to the rows in Master sheet so if JOHN is moved from A2 to A4 in master sheet than the B1 in sheet named "4" has JOHN. what I need is a macro that will move JOHN data in column A in Sheet named "2" to column A in sheet named "4". In other words I need the data from each sheet to move with the Name. Usually a name will be moved down when new names are added therefore

A1	BOB
A2	BETH
A3	KIM
A4	JOHN
A5	PETER
A6	SMITH
A7	LIZ
A8	TOM

<tbody>
</tbody>

Or the other scenario can be that a name is removed and that the names below will be moved back up. so the data with each header needs to move when the Names move to different sheets.