Reference a Workbook Name from Cell Data

Hello! I have data arranged in files that are named with a prefix and a date, for example, “abc 2018-03”

I have another file that pulls from individual cells within each of the dated files. If, in my summary file, I put “2018-03” in as a label in cell B2 and “2018-04” in C2, for example, right now, I have to copy the function that references say cell c3 of sheet1 in 2018-03 from B2 and C2 and edit the formula. It wouldn’t be so bad, but there are several to do and therefore several opportunities for error. How can I set it up to autofill, using the reference in row 2?


It can be done with INDIRECT() function like:


creating the link as text inside the function.