syntax to select cell in another sheet based on offset of active cell in current sheet

I have been trying to develop a client data input form that is referenced by a printable output form in another sheet. What I am struggling with is how to have my code make changes in the output form based on the cell input in the data entry form. For example, if I want to add a row in the data input form (Cell A17) and that corresponds to adding a row in the output form (Cell A7).

So my question is how can I write a code to create an offset based on active cell (active sheet) to another sheet?

Submit a workbook example

I would preferably like avoid using the message box, but that is the work around at the moment. Ideally, the corresponding addition in Networth just happens....

1. Go to Client Data. Click in Cell A24
2. Go to Networth. Click in A9.
3. Go back to Client Data. Click Add Row.
4. Now when you enter in new data in Row 24 it automatically gets added to Networth under the relevant section.

Trying to avoid step 2...

Sub Add_Rows()
Dim ws1 As Worksheet:   Set ws1 = Sheets("Client Data")
Dim ws2 As Worksheet:   Set ws2 = Sheets("Networth")
Dim lRow As Long
Dim str As String
Dim rFind As Range

If Selection.Rows.Count > 1 Then
    MsgBox ("You can only have 1 row selected")
    Exit Sub
End If

lRow = Selection.Row
str = ws1.Range("A" & lRow).Offset(-1).Value

Rows(lRow).Insert Shift:=xlDown

Set rFind = ws2.Range("A1:A" & ws2.Range("A" & Rows.Count).End(xlUp).Row).Find(What:=str, LookIn:=xlValues, LOokAt:=xlWhole)
If Not rFind Is Nothing Then
    rFind.Offset(1).EntireRow.Insert Shift:=xlDown
    rFind.Resize(2).EntireRow.FillDown
End If

End Sub

I have no idea what you mean.

This thread was reposted in Commercial and solved. Thanks everyone!