I use vlookup to link multiple workbooks, sometimes the value dose not appear
unless the source workbook is opened. It is very time consuming to open
multiple workbooks to enble the linked value return to my workbook.

There is another issue, some of the value appear from same source workbooks
some don't.

Please advise how I can solve above issue.

Thank you