I have multiple workbooks with names like 05_091606. The 05 refers the store which will remain constant. The last 6 numbers refer to the week date which will change weekly. Any ideas on how i can link these weekly to one workbook while the names are changing weekly? I have 15 workbooks.
Dan
Dan