Retrieve specific cell data from multiple workbooks

[Redda_joppe]

Hello, I have a register of workbooks. The register is created by using power query That retrieved all well files within a folder and sub folders. Each workbook contain some information that will be useful to have in register as well. the register contains

workbook name. Workbook path. Finish date
abcde.xls. C:\\ document\… cell I14

the location of the file is in different folders

is it possible to do this without opening all workbooks