A built in option were Sheet numbers are renumber automatically, for this function there was a add in called "Renumbering Sheet" by D'Bim Tools, but they stopped uploading newer versions as of Revit 2022. Maybe would be good to get there add in as a base for built in option in newer versions of Revit. I tried to do it by making a dynamo script, but it was a messy script with lots of python scripts.