We currently operate in a peer-to-peer environment, but
are soon migrating to a file server. Our principal
currently maintains our project schedule in an Excel
worksheet residing on his PC's hard drive. We develop
several cost estimates and revisions thereof for each
project.

Frequently, we review an old estimate, using the schedule
to determine the project number and who prepared the
estimate, and then look in the Shared folder of that user
to retrieve the estimate. In other words, a lot of
productivity-killing navigation. We experimented with
hyperlinks, but since they're linked to a specific file,
they're quickly out-of-date.

So, we'd like to develop a "smart" hyperlink that takes us
to the last revision of the last estimate from the drive
of the estimator, the initials of which is maintained in a
column of the schedule. Our file naming convention is:

<projectnumberE<estimatenumber[R<revisionnumber], e.g.,

04003E1
04003E2R1
04003E2R2

Can anyone assist us?