Excel sheet hyperlinks linked to a server that's changing locations

Hi,

I am creating an Excel sheet which is going to have numerous links to drawings.  If the drawings were going to be hosted on one particular server I would just statically map the link for each drawing back to the server.  Since in our case our shared space sometimes switches to another server is there a way to extract the server location based on where the excel index file is stored then append the sub-directories to that to form the link to the drawings?

Jon