I am working on a exel project that is gathering data from cells in a few other work books. These workbooks are updated weekly and renamed to the end of the week which is saturday (example: week ending 12/3/05). Is there a way I can have these links automatically identify the newly created workbook and pull the appropriate times from the workbooks they are linked to without going through each cell and chaning the file name manually for each one?