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:

[TABLE="width: 100"]
<tbody>[TR]
[TD]A1[/TD]
[TD]BOB[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]JOHN[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]PETER[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]SMITH[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]LIZ[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]TOM[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 100"]
<tbody>[TR]
[TD]A1[/TD]
[TD]BOB[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]BETH[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]KIM[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]JOHN[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]PETER[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]SMITH[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD]LIZ[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD]TOM[/TD]
[/TR]
</tbody>[/TABLE]

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.