If you need quickly to perform a check for all legends and schedules that are included in your drawings then this script can be a good tool for you.
The script does not have a user interface. It will export a list to Excel for all drawings. In case that you have on the one sheet, more than one schedule or more than one legend the script will merge names to fit into the one row.
The reason why data will not appear in the same order as in Revit is that I did not sort data before export. So if you want to improve the script you can include sorting.
Please make sure that before you start using this script that you back up your existing project model.
Also, if you want to download this (and all other scripts) with my sample files please visit the Shop page.
The script uses the following Dynamo packages: spring nodes v.203.2.0 BumbleBee v.2021.25.3