lookup particular cell data from a folder of files

Is it possible to lookup a folder of files and get the data from it, eg: i got a folder of excel files from 1st Jan to 31st Jan, i want this cell on another workbook to show the data of 25th Jan's particular cell.

The file names are 100101 100102 100103 all the way to 100131, instead of opening 1 by 1 to get the data from them, is it possible to lookup using formula and link the data to another workbook?

Thank you

one approach - based on your file:

M5:
=INDEX($B$4:$J$31,COLUMNS($M5:M5)+2*(ROWS(M$5:M5)-1),MATCH($M$4,$B$2:$J$2,0)+2)
copied across matrix M5:N18