macro's to open workbooks and update job lists when time cards are opened but the job code list is in an other folder

[BMJA]

I have created time cards with drop down lists for employee names, job lists, and task lists. in the workbook there are 26 worksheets for time sheets one for each pay period, and a master list of employee names, job list and task list. When I go into update the lists in each employee's folder and update the list then I have to save it as a copy and the employees basically have to start a new time card. I would like to be able to update a master list of job codes and every time they open their time cards it would get the updated drop down list from another folder, but on the same drive. I'm not sure what the best way to achieve the out come that I need.
Thanks