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