Create a "Revision Record" as part of the project.
It would show the sheet revisions per model. The current revision could be collected by Model Metrics or dbexport tasks or the Revit Clarity Client addin. Everytime a new revision is added to the project revisions it gets added the Revision Record.
Once the current revision is added to a Sheet, That Sheet number and name is added to the Revision Record.
This would be displayed in a webpage like a schedule to show all the sheets revision history per RVT model for the clarity project. This record should be exported