Macro to name sheet to specific custom property

I have been trying to make a macro but haven't had much luck so far, I pulled a macro from another post listed on here for naming sheets after a configuration name and trying to edit it to fit my needs.  What I have is a drawing with 4 sheets and custom properties set up for creating the name for each sheet (ie. Sheet 1 Name, Sheet 2 Name, etc.).  Now the issue I'm having is getting the sheets to be named after those custom properties.  The "Sheet # Name" custom property is generated from some other properties I am using and combined to create the name.  Not sure if this is the best way to go but I figured it would end up with just one property to grab to rename the sheet.

This is the topic from here that I pulled the macro from that I tried working with but I didn't get far at all.

Any help is greatly appreciated.

SolidworksApi macros