Cell value is the document name - Vlookup

Hi!

Know this is an old post, but I hope someone reads it.

I have the same problem. Want to define the path to the worksheet in a cell. Then use this cell as a reference for my formulas in other cells. I have a lot of workbooks to draw data from + a lot of formulas so really need this one.

Perhaps you would describe for me in detail how to do this, beccause I didn't understand the link too well..


Thanks
/Henrik