CE - Sheet Index sheet name

Can anyone tell me if it is possible to assign the first 4 digits of a project folder name to the prefix of the sheet name and have the Sheet indexing tool pick up this value and assign it to the sheet name

I think I speak to most MS users.  A project will consist of a project name followed by a description. ie 1777 East Ham Market. (see below). Thus, within the sheet name the actual sheet file will be called 1777-0001, 1777-0002 etc.

This means the sheet indexing tool cannot assign a sheet name. 

Ian Lapper

Advanced Integrated Solutions