Changing name of Source Workbook

[sdcamp3020]

On Jan. 1st my Jobs List folder will be archived due to the size and the file name changed to "Jobs List 2008-2011". For every job on the Job List, I have a separate workbook that tracks time and expenses for that particular job. Every individual Job Worksheet has a link back to the Job List workbook that pulls the Job Name, Purchase Order Number and Quote Amount. Does anyone know a simple way to change the source link in the individual workbooks (approx. 2000 workbooks) without having to manually do so in every one? Thanks for any advice!

 

[Myproblem]

try on this link to change source:
Change the source of a link - Excel - Office.com

 

[sdcamp3020]

Thank you for the link; however, that is the solution I am trying to avoid. I was hoping for a way to change the external links without having to open approximately 2000 workbooks to do so. I appreciate your reply!