Hey,
So I'm trying to create a file for me and my 8 other colleagues where we, on a weekly basis, keep track of our mails and calls received. I created a second workbook on the side for our supervisors which is updated daily/ weekly when they open it and get their needed data from it. the issue i'm having is that when i create the file, i can just use the typical =[Daily counts - NAME - Week X]Monday!$L$4 to get that single cell to it. but the week after that same file will be called a different name and it won't update in the supervisor file. How can I get it so that there's a permanent link between the two, even if the name changes?
Bookmarks