Accessing data from a separate, closed workbook in a distinct folder tree, but without knowing the workbook name

Hi, sorry if the title is confusing, but I am wondering if there's a way to automate accessing data from a .csv workbook when I won't know the workbook's name ahead of time.

I have some automated data collection happening, and it generates workbooks in .csv format, with the timestamp of the data as the filename. Because the filename is a timestamp, I cannot predict it ahead of time, but I do have a unique folder for every result genrated.

Is there a way to use VBA or Power Query along with some of my cell values to provide a folder path and have my sheet automatically extract the desired values from whichever .csv is contained in that folder?

For example, my columns might be:

Region1, Person1, Department1, <Value Array>

And my folder structure would be

.../Region1/Person1/Department1/<timestamp>.csv 

Is there any way to automatically grab one row's worth of data from that CSV given that it's the only file in that folder?