I have 2 workbooks (Workbooks A & B) that are created with updated data almost on a daily basis, but each day is saved as a new file. Both workbooks have a different name format, but contain the date in the name and are saved in different folders. Workbook A has the latest saved date (not always today's date) in B4. Is there a way that Workbook A can find the corresponding Workbook B (with the same date in the file name as Workbook A cell B4) and open that file to use as it's database to pull data?