Referencing a Closed Workbook using a cell value as the workbook name.

[NoviceExtraordinaire]

I need to reference specific cells in a bunch of closed workbooks.

Example: ='C:\Users\UserA\Workbooks\[WorkbookA.xlsx]Sheet1'!E13

Typing the workbook names for every reference is clearly a waste of time. How can I call in the workbook name into the reference formula from a list of names that resides in the same sheet as the reference formula. In the example above my thinking is to replace WorkbookA with a cell reference like A2 or A15 from within the same sheet. All of my attempts have failed. 

[#2]

@NoviceExtraordinaire 

I didn't read carefully but perhaps here https://stackoverflow.com/questions/28461672/referencing-value-in-a-closed-excel-workbook-using-indi... is some workaround. Simply using INDIRECT() doesn't work with closed workbooks.