Capture.JPG
Screenshot of example rows

Spreadsheet file: Test Training Sheet.xlsx

This is the macro that I first recorded with relative references:

ActiveCell.Offset(-2, -3).Range("A1:L1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(0, -1).Range("A1").Select
ActiveCell.Rows("1:1").EntireRow.Select
Selection.Replace What:="Billy Bob", Replacement:="Joanne Sue", LookAt:= _
    xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=False
End Sub
My goal is to have, say, Row 1 be the example row that would be copied into all other rows. The only difference would be the name in Columns B and C. This name corresponds to the links in the cells like so:

='G:\WORK\Test folder\Test\Employees\[Billy Bob.xlsx]Sheet1'!$E$2
I would want the macro or code to look through and change "Billy Bob" to whatever is entered into the B cell of that row. The name in each row is linked to it's own spreadhsheet. All the cells in the row pull from that individual spreadsheet, so their links need to correspond to the name in the B cell.

However, I can't get my macros and vba code to work and would greatly appreciate any assistance or advice!