Get the code here https://www.bluepecantraining.com/excel-vba-import-most-recently-created-file-into-current-workbook/

This video demonstrates how to open the last created or most recently created workbook within a folder and then to copy or import that date into the current workbook. The solution uses VBA's FileSystemObject.
------------------------