combine reference to workbook and cell

I'm trying to create a formula that references an external workbook location in row A to retrieve information to create a master summary reference workbook.  Using the table below as an example, I wa...