Create an INDEX formula in VBA where one cell is based on ActiveCell

I have this formula created in excel vba:

PHP Code: 

 Selection.FormulaArray = _
                 "=INDEX(Data!R1C8:R1000000C8,SMALL(IF(R2C2=Data!R[-4]C3:R1000000C3,ROW(Data!R[-4]C3:R1000000C3)-MIN(ROW(Data!R1C3:R1000000C3))+1,""""),ROW(Data!R[-4]C3)))" 


What I am trying to do (I dont' know if it is possible) is have R2C2 [SMALL(IF(R2C2) ....] be based on an activecell. Specifically, ActiveCell.Offset(-1, -3).
Is this possible?

I am trying to do this because this formula is in a loop and I need it to stay the same within the loop but change every time the loop re-loops.
Here is the part of the loop I am working on:

PHP Code: 

     Selection.FormulaArray = _
                 "=INDEX(Data!R1C8:R1000000C8,SMALL(IF(R2C2=Data!R[-4]C3:R1000000C3,ROW(Data!R[-4]C3:R1000000C3)-MIN(ROW(Data!R1C3:R1000000C3))+1,""""),ROW(Data!R[-4]C3)))"
            Dim x As Long
            x = ActiveSheet.UsedRange.Rows.Count
            ActiveCell.Copy Range(Cells(6, ActiveCell.Column), Cells(x, ActiveCell.Column))


             ActiveCell.Select
        ActiveCell.Offset(0, 1).Activate
            Selection.FormulaArray = _
                  "=INDEX(Data!R1C9:R1000000C9,SMALL(IF(R2C2=Data!R[-4]C3:R1000000C3,ROW(Data!R[-4]C3:R1000000C3)-MIN(ROW(Data!R1C3:R1000000C3))+1,""""),ROW(Data!R[-4]C3)))"
            x = ActiveSheet.UsedRange.Rows.Count
             ActiveCell.Copy Range(Cells(6, ActiveCell.Column), Cells(x, ActiveCell.Column))

             ActiveCell.Select
         ActiveCell.Offset(0, 1).Activate
             Selection.FormulaArray = _
                 "=INDEX(Data!R1C10:R1000000C10,SMALL(IF(R2C2=Data!R[-4]C3:R1000000C3,ROW(Data!R[-4]C3:R1000000C3)-MIN(ROW(Data!R1C3:R1000000C3))+1,""""),ROW(Data!R[-4]C3)))"
             x = ActiveSheet.UsedRange.Rows.Count
             ActiveCell.Copy Range(Cells(6, ActiveCell.Column), Cells(x, ActiveCell.Column))
            
         ActiveCell.Offset(rowOffset:=-3, columnOffset:=4).Activate 


Any advice?

Thank you!