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

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.