Is it possible to link 2 spreadsheets with v-lookup

To create a spread sheet that auto fills information from another spreadsheet by using v-lookup.

What I would like to do is enter into one field the name of the excel work book and have the v-lookup and be an = function to the field I want it to point to so I can store multiple data on one sheet with out have to manually create it.

IE if my normal function is ='[11 #13.xls]11 #13 '!$B$20....How would I go about doing this. I believe I have seen it done in the past.

IE IF THE VLOOKUP FIELD COULD BE ENTERED TO APPEAR LIKE THIS.
='[vlookup.xls]vlookup '!$B$20. and I could enter in the name of the vlookup info in the tab next to it.


Whenever I try it
='[(VLOOKUP(B2, 2, B2,B2:[B28, FALSE)).xls]]B28, FALSE)).xls](VLOOKUP(B2, 2, B2,B2:[B28, FALSE))'!$B$20 when ever I try it I get reference errors.

tHANKS FOR THE HELP