Consolidate using VBA

I'm trying to use the consolidate function in a macro. I have recorded a macro and have tried to edit it but my issue is that in the array I don't want to hardcode the name of the workbook., instead I want it to refer to a named range.

The code I recoded is below:

Selection.Consolidate Source:=(Array _
"filepath[filename].ResultsC!R12C6:R4361C60"), _
Function:=xlSum, TopRows:=False, LeftColumn:=True, _CreateLinks:=False

But I want to replace the filepath and filename with something that can change.

The code I've written is below:

Dim strWb As String
strWb = CStr(ThisWorkbook.Sheets("Control").Range("rngWorkbook").Value)
Workbooks(strWb).Activate

Range("BJ12").Select

Selection.Consolidate _
Sources:=Sheets("ResultsC").Cells("R12C6:R4361C60"), _
Function:=xlSum, TopRows:=False, LeftColumn:=True, _CreateLinks:=False

Where the name of a workbook has to be entered into a separate workbook on a sheet called Control and in a named range rngWookbook.

If I I run the code above or use "Array" after "Sources:=" it comes up with error 1004 "applicaition-defined or object-defined error".

I hope you can help!