Import Data in a cell to another workbook, automatic update by Date

Hello!

I'm trying to import the number in a cell to another workbook

For example;

Source file name is 01042021
BF LN DN
KOR 40 20 22
JPN 20 30 31
IND 15 10 12

Report file
KOR worksheet
01/04/2021 40 20 22
02/04/2021

JPN worksheet
01/04/2021 20 30 31
02/04/2021

IND worksheet
01/04/2021 15 10 12
02/04/2021

Whenever the numbers in 02042021 file are updated, the numbers in Report file, every sheets should be updated.

I have created all source files from 01042021 to 31042021 and a Report file with 3 sheets as same as in the example. And the updated data in the Report file must be static.

Thank you for any help!

Caine

There are instructions at the top of the page explaining how to attach your sample workbook.