Access 2010, VBA & linked tbls

I created a db which I have split. I am also pulling data from linked Excel reports that each user will download and save into the same sub directory of their Documents folder. These reports will have data unique to specific to the sales director. So how do I deploy this so that the linked tables will be reconnected based on the current user. If I deploy to my husbands machine I have to manually go to the linked table manager and relink each table. I can't expect the other 3 users to do that or walk them through it especially since they are in different states.