I have a large number of seperate files that I would like to compile together into a single book. To do this, I want to tell it to reference a certain column for the name of the book, which amounts to parsing that string and then using that value in the formula to find the value.

Something like =[EVALUATE(filename)]Worksheet!B2

Is there a way to do this without VB?