I have a similar issue as this post that Olly solved

1195425-append-multiple-dbf-files-in-powerquery

except that I have the file with a consistent file name adjtime.dbf, but it is in a different folder for each day i.e. 05192020\adjtime.dbf, 05182020.dbf.

I think the code in this case is similar to my problem, but the use of odbc is throwing me off because an odbc entry and folder name are a 1 to 1 correlation.

So I resorted to an oledb call that looks like this, which works great, but I need to parameterize the folder name?

= OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Users\jzimm\Downloads\aloha\20200519;extended properties=dBASE IV", [Query="select * from [adjtime.dbf]"])