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 want to paste the file path in the first column, then in the second column have a formula that references the file path in the first column and adds the cell reference I'd like to retrieve information for, then repeat for each of the other columns. 

This way I can simply paste the workbook address for each new project, copy the formulas in "Project Name", "City, State", "Acres" and "Rent per Sq.Ft" down to the next row and have each of the associated columns automatically retrieve that information instead of having to map every cell independently, or perform a Ctrl+H to replace the file paths.