replace data for multiple sheets from source file to destination file based on back up(date,time)

[leap out]

Hi guys,
I have many source files contains REPORT_09082024_20:00:00 so will contain REPORT word and format date and time(ddmmyyyy_hh:mm:ss)
and the destination file will be REPORT (other meaning the REPORT file will be open )
source file contains multiple sheets , destination file (REPORT file will be open) contains the multiple same sheets with comparison source file .
my goal should replace data in multiple sheets in REPORT file is open based on the same sheets are existed in source file
but when import data from source file should import based on the last time for date(today)
example : I have source files (REPORT_09082024_20:00:00,REPORT_09082024_20:00:01,REPORT_09082024_20:00:03) then will import data for multiple sheets based on REPORT_09082024_20:00:03
all of files will be in the same folder "C:\Users\lpp\Desktop\MTT\"
every time run the macro should replace data for each sheet in REPORT file based on last time for date(today) for each sheet.
thanks

 

[leap out]

Bump.