How to link network documents?

I've made an index in Excel for a large collection of documents and need to link them all for others to use. Is there a way to do this even though we have different names for the network the documents are on? Like for me the server will be "Bob" but my coworker sees "Joe"?

I've also been given the task of making it possible for the entire collection to be sent out of company and still usable, but that seems farfetched. I absolutely cannot upload things to the Internet.