Is there a way I can use a date from a worksheet cell..example dat = cell("H2")? In order to get the date? I am not sure how else to explain it. Other than I receive the Sched workbook (Sched 11.30.25). I create a workbook for picks from that schedule to add to it (Shift Pickup 11.30.25). On 11/24 I receive another weeks schedule (Sched 12.07.25). Again I create another workbook (Shift Pickup 12.07.25). The date is the only thing that changes on the workbook titles. So like today WB Shift Pickup 11.30.25 was created with dat =Date - Weekday(Now(), 1) + 15, and today I had to go in and change it in that specific workbook to dat=Date-Weekday(Now(),1)+8 while the other workbook remains at +15. As we move into next week I will have to go into that specific workbook and change 15 to 8. Hopefully that explains it better. I am looking for a way to make it read and tell the difference between which workbook to look at. This is also used to open and close two other workbooks as I input names into the Shift Pick (Date).