Each week a new workbook is created for deliveries.
I want to create a master workbook that links information from this week’s delivery’s workbook.
I was planning to simply name the delivery work books based on the week number.
Then in the masterwork book to link the information based on this week’s week number..
So for example..
Cell A1 knows the date =TODAY()
Cell A2 generates the week number =WEEKNUM(A1,2)
Cell A3 link a cell in a different work book =[38.xlsx]Sheet1!$E$4
Is there a way to get the 38 to come from cell A2?
Or am I going about this wrong, and is there a better way?
Any help would be great