Indirect to another workbook

  • Hi All,


    I have several (50) workbooks for which I am trying to create a dashboard in order to show a summary of all work.
    All workbooks are always in the same location but the summary sheet may not be (does this matter ?)


    I create a list of all workbooks in Cell A1:A50 on a sheet named dashboard within a workbook called "Summary of Work"
    i.e.
    A1= "Case 1"
    A2= "Case 2"
    etc


    How I can reference the names (without a suffix) "Case 1" to make reference to the "Case 1.xslx" with the indirect function


    Also,
    None of the reference workbooks will be open, so I am not sure if Indirect will work?
    Maybe the index-Match function instead?


    Any help is very much appreciated


    Thank you