The attached has such a query. Currently it's looking at
C:\Users\Public, you'll need to adjust that to your base folder. Thereafter you'll need do nothing except refresh the query to update the results. You refresh the table in the same way as you refresh a pivot table: eg. right-click the table and choose
Refresh.
To change the base folder, alter the first line of the query:
2023-02-17_180603.png
or we could put the base folder in a cell and have the query look at that cell, and that cell could be updated with a tiny macro to let you browse for that base folder.
At the moment I've opted to show only unhidden directories (folders), but that can be much more finely tuned.