I need help from the great minds in this forum: So here is my problem............

I want to pull data from my excel file (using VBA) into Ms Word. I created a template in Word and wrote a macro to do this, it worked, however, anytime a new row is inserted or deleted in my excel spreadsheet my macro produces wrong results in my Ms Word template because the cell position has shifted, thereby producing the wrong result. How do i make it that my result remain the same when new row is added to my spreadsheet.

Example: Excel row1: vicky 528
row2: sam 532
row3: john 092
row4: Own 211 word template: 092

This is what happen next:

Excel (New row added) Macro: ThisDocument.ScreenedPatients.Caption = wb.Sheets("CSAs").Cells(16, 1)

row1: pat 542
row2: vicky 528
row3: sam 532
row4: john 092
row5: Own 211 resulting Word template(running macro): word template: 532


But i want John to automatically go on the Word template without going into macro to change it all the time when a new row is added. I hope this is not too much to ask. I appreciate the help.