I know it's possible to generate a list of files and folders in a specified directory using VBA in Excel. I know the save structure is a bit wonky in OneNote, but is it possible to do something similar with VBA in Excel?

My situation is this:
I have a notebook with ~15 sections and ~400 pages per section and growing. I am working at manually making an index but obviously that will take a ton of time. I'm wondering if there is a way, using VBA in Excel, to make the job easier.

Thank you!