getting data from a closed file using a list of files names from a drop list

I try to better explain the problem I have already posted from which I had very good help and learned few thinghs so let me start with a thank you

I have a list of files name in a drop list (source is column AU) and files location is written just as a sample reference.

I would like to be able to select a file from the drop list and have the value in cell L10 of the selected file to be reported in the column “value” of the table

I tried using the indirect formula combine with INDEX and MATCH but I have learned from previus post that is not working if the target file is not opened. For my pourpose I defenetly nedd the file not to be open. Im scared that using VBA will be too advanced for my rookie skils but if not possible with just formula I will consider using VBA and improove my skill

Thank you for your time