I created a workbook that use data from another workbook (Data Workbook). The data in the Data Workbook name is changing from time to time. I'm using the Edit/Link/Change Source to update the new link

1. Is there a way to automate the procedure
2. Is there a way to get the current link in the spreadsheet (as a formula or link) that will reflect the actual link ?

Thanks, Nehemia