The @name property should update automatically. Have you embedded the property in the sheet border symbol, or have you added it manually to the schematic?
One additional comment, to see the change you need to perform an update, use Tools - Update Other Objects - Properties.
The @name property returns the design name, not the sheet name.
In a multi sheet schematic using the @name property on each sheet returns the same name (the design name) on each sheet.
How can I make the sheet name appear in the border ?
In the PADS Flow you can use the property @sheet for "sheet name". This property was defined in the netlits.prp file and I placed it inthe border symbol.
...and it works. (hope, also in Expedition Flow).
Best regards Klaus