Creating link to source workbook in VBA

[Jakrae]

Greetings community.

I'm very new here, and I am fairly new to VBA macros. I understand most of the basics, but I may need answers dumbed down a good bit. With that disclaimer out of the way, here is my questions.

Each customer has their own detailed checklist of processes (so separate workbooks for each customer), only the major points are sent to a single master list workbook as each section (instead of item) is completed . I want one of the rows to have a link back to the source workbook (or folder) that the data came from so I don't have to go to each individual customer folder to open the details, just click the link in the master list.

I was thinking that there's a way to reference back to "thisworkbook" (this is the one where the macro is stored, right?), but I have no idea how to make one of the cells made to a link back to the source workbook.

Here is my basic sloppy code without trying to add the links (file names and paths have been changed):

[INDENT]Sub Copy_Insert_3()[/INDENT]
[INDENT]'[/INDENT]
[INDENT]' Copy_Insert_3 Macro[/INDENT]
[INDENT]'[/INDENT]
[INDENT]Dim wb As Workbook[/INDENT]
[INDENT]Set wb = Workbooks.Open("X:\...MASTER LIST.xlsx")[/INDENT]
[INDENT]    Windows("MASTER LIST.xlsx").Activate[/INDENT]
[INDENT]    Rows("3:3").Select[/INDENT]
[INDENT]    Selection.Insert Shift:=xlDown[/INDENT]
[INDENT]    Windows("TASKS.xlsm").Activate[/INDENT]
[INDENT]    Sheets("Sheet2").Select[/INDENT]
[INDENT]    Rows("2:2").Select[/INDENT]
[INDENT]    Selection.Copy[/INDENT]
[INDENT]    Windows("MASTER LIST.xlsx").Activate[/INDENT]
[INDENT]    Rows("3:3").Select[/INDENT]
[INDENT]    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _[/INDENT]
[INDENT]        :=False, Transpose:=False[/INDENT]
[INDENT]    ActiveWorkbook.Save[/INDENT]
[INDENT]    Windows("TASKS.xlsm").Activate[/INDENT]
[INDENT]    Sheets("Sheet1").Select[/INDENT]
[INDENT]Workbooks("MASTER LIST.xlsx").Close SaveChanges:=True

 Windows("TASKS.xlsm").Activate[/INDENT]
[INDENT]End Sub[/INDENT]

I ran a few Google searches to no avail (might just be using the wrong terminology in my searches).

Thank you in advance for pointing me in the right direction! I'd like to learn how to do it more than simply have one of y'all do it.

Jakrae.