So here’s the rub…Dynamo/Revit API can give you every single Revision on a Sheet. The code req’d is Sheet.GetAllRevisionIds(). You could then easily send that to Excel and generate a schedule. But you are trying to work with Revit’s schedule/sheet list. That means each column in the schedule needs to correspond to a shared parameter that is available to the Sheets category - so you have to create a shared parameter for Each and Every Revision/Sheet Issue. So technically, you could write a script to do what you want, but you’d need to provide the necessary parameters for the script to tell Yes/No - and unless you can see into the future how many revisions and sheet issues you will have, it’s going to be tough unless you are ok editing your script every single time to accomodate the new parameters.
Technically you could work with project parameters if you were in a bubble and only concerned with sheets internally (and this would allow you to possibly write a script that would automatically create the project parameters on an as-needed basis depending on the number of revisions in the project), but if you want your consultants to also have access to the same parameter for a unified sheet list, you will have to use shared parameters.