Any way to link drawing sheet tab to model parameter? (macro or api?)

Currently our system admin has set up a fantastic template that automatically fills in our title block based on custom parameters in the model file. I'm wondering if it's possible to get the drawing sheet tab to be automatically renamed based on one of these parameters. For example, see attached image.

I've renamed the tab to match the part number listed in the title block. I am going to be adding additional sheets, and I'd like each one to have the sheet tab match the part number shown on the drawing (these are family parts, so all parts are shown in a single drawing, but on different sheets).

Are you sure that you want to add a family of parts to the same drawing?

We tried something similar here, in which we created all drawings of all parts in a particular assembly in the same drawing, just on different sheets. (this was because all our parts are custom made for a particular assembly).

The problem that we ran into, was when a particular assembly became more and more complex, the complexity of the parts paired with the number of sheets that we needed started making the drawing very flaky. We began running into many issues where sheets wouldn't update, or views would be lost, just by closing and re-opening a drawing.

For non-complex parts/assemblies, it was no issue, but with more complexity came more problems.

Out solution was to split them all into separate drawings and this fixed all our problems. Now we only use multiple sheets if we need more space.

Just a curiosity on what your company did for having multi-sheet. Did you ever do situations where you had a single drawing for a multi-configuration file or only where they were completely separate parts in an assembly. Just curious as I've done the former and called out dimensions that reference a table which lists out the different variations of the part. Sometimes views of other configurations of the part have to be included on a separate page to call out configuration specific features. Do you see any potential risk in doing this? I haven't run into anything yet but wanting to know if I need to be on the lookout.

The issue we were running into was that we had some massive complex parts (20-30 of them) all on separate sheets along with the assembly drawing and its exploded view. Almost every time we opened these, we had problems and had to re-do some portion of it. Although we probably could have opened it lightweight, that really never occurred to us.

Basically, the bigger the file size of the multi-sheet drawing, the worse it got.

I am not saying to stay completely away from multi-sheet drawings. We still use them from time to time (i.e.: adding an exploded view to a sheet 2 or needing a second sheet for more views for a complex part). These seem to work just fine.

The other issue we ran into was revisions. The revision system that SolidWorks has breaks down when you have different parts on the same drawing but on different sheets, as we were not using it as it was intended.

Going back to separate drawing for separate parts fixed all those problems.

EDIT: that was also when we use SW 2013 and 2014. We haven't really tried it with SW 2015.....maybe that problem is fixed.

Like any other. These designs are very simple family parts. Think fasteners. Not much changes after parts are released for production, and when something does change, it affects everything. We are getting off topic, however.