Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
Google NotebookLM lets you load up to 50 sources and 25 million words, then answers with citations so you can study faster.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results