Using filename as variable in external reference formula

I am trying to automate several time consuming tasks.
I have ~25 worker logs used in new worker training.
I have a summary sheet that gathers information from each of those logs.

I currently have the log creation process automated, but I would like to automate the creation of the summary sheet as well.
The log creation process runs several log creation macros in a "For i =1 to lastrowA1" loop.

One of the variables derived from that loop is myfilenames(i). I want to use the myfilenames(i) variable in formulas, replacing the worker name so that I can run a macro to create the needed external references in the summary view and pull the table data from the individual worker's tables into a master table for analysis.


Current code:

ActiveCell.FormulaR1C1 = _
        "='[Case Review - Alison.xlsx]Stat Summary Aug-01 thru Sep-29'!R16C3"

What I have tried so far (and doesn't work)

ActiveCell.FormulaR1C1 = _
        "='[Case Review -  & myfilenames(i) & .xlsx]Stat Summary Aug-01 thru Sep-29'!R16C3"

How can I make this type of formula work, where part of the filename is a variable?


Attachments:
Log creator (using module 7 as test module)
Alison (example worker log)
Ginny view (summary sheet)