Adding a map sheet name as dynamic text using an expression
The map sheet name from the current map sheet or a neighboring map sheet can be added to the map sheet using a VBScript expression. Using a VBScript expression allows you increased flexibility in formatting information displayed in a dynamic text.
 Note:
Note:The ability to use neighboring map sheets is only effective when their areas of interest (AOIs) are relatively contiguous and regularly-shaped.
- Start ArcMap.
- On the main menu, click Customize > Toolbars > MPS Atlas.
- 
Click the Add Dynamic Text button  on the MPS Atlas toolbar. on the MPS Atlas toolbar.A crosshair with a letter A appears. 
- 
Click anywhere in the map sheet layout.
A piece of dynamic text is inserted on the page. 
- 
Double-click the dynamic text.
The Dynamic Text Properties dialog box appears. 
- Click the Dynamic Text tab if necessary.
- Click the Dynamic Text drop-down arrow and choose Map Sheet.
- 
Click Insert.
A map sheet text appears in the text box. 
- 
Click the dynamic text element in the text field.
The Map Sheet Dynamic Text Properties dialog box appears.  
- Click the Expression option.
- 
Click Edit Script.
The Expression Parser dialog box appears.  
- In the Expression area, click to right of the Generate = expression.
- Double click a field name in the Parameter list.In the Expression area, the field name appears to the right of Generate =: Generate = [NAME].  Tip: Tip:Double click a field name without an _arr suffix. 
- Click Verify.The Output area lists Function evaluated successfully. 
- Click OK to close the Expression Parser dialog box.
- Click OK to close the Map Sheet Dynamic Text Properties dialog box.
- Click OK to close the Dynamic Text Properties dialog box.The dynamic text displays in the page layout. 
 Note:
Note:If you change the layer or data frame, the expression will be cleared. A new layer will require a new set of function parameters.