[VBA] Locking Rows to certain reference cell

[gomgom2]

Good Morning.

Thank you for coming into my thread.

What I am trying to figure out is if I can lock the rows to a certain reference cell.

I will do my best in explaining. Please hear me out.

I have two sheets in which information is inputted through rows.

Sheet1
Names|Item|Item2|Item3|
John | adf | adf | adf |
Grace | adf | adf | adf |
Kennen| adf | adf | asd |

For Sheet 2
Names| Date1|Date2|Date3|
=sheet1!A2 (John)| 2/2 | 3/3 | 4/3 |
=sheet1!A3(Grace)| 2/6 | 3/2 | 4/4|
=sheet1!A4(Kennen)| 2/4 | 3/4 | 4/5|

Problem happens when I have to rearrange the rows in sheet1 such as in ascending order or insert the row in the middle.

Because then, the dates would not match the data in sheet2.

Of course, there is a manual way to amending it but I figured there might be a way to do this more easily.

So I was wondering if there is a way to lock the datas in sheet2 to column A cells. This will allow me to move around the rows in sheet1.

Any comment or advice is highly appreciated.

Thank you.

 

[mole999]

$A$3 should lock to A3 always, the $ sign

 

[gomgom2]

Sigh... if it were that simple, I would not have posted this...
If I rearrange the places between GRACE AND JOHN, then sheet2 will show the mixmatch.

Sheet1
Names|Item|Item2|Item3|

Grace | adf | adf | adf |
John | adf | adf | adf |
Kennen| adf | adf | asd |

For Sheet 2
Names| Date1|Date2|Date3|
=sheet1!A2 (GRACE)| John's birthday| John's address | John's phone number |
=sheet1!A3(JOHN)| GRACE's Birthday | GRACE's ADDRESS | GRACE's PHONE NUMBER|
=sheet1!A4(KENNEN)| KENNEN's BIRTHDAY | KENNEN's ADDRESS | KENNEN's PHONE NUMBER|