It would be nice to export out all of the data about the sheet to a spreadsheet. Especially the item type data (sheet no, total sheets, title, drawn by....) Make any changes in the spreadsheet and then import the data back in and update all the sheets.
Export is already possible with Reports. Unfortunately, as far as I am aware, there is not a way to edit the values in reports. Neither directly (see this IDEA https://microstation.ideas.aha.io/ideas/MSR-I-996), neither trough import.
For Item Types there is the Import/export tool: https://docs.bentley.com/LiveContent/web/MicroStation%20Help-v19/en/ItemsImportExport.html. But it's not ideal for this workflow.