Copy value from multiple workbooks in the same folder

Hi Guys, i am looking for an VBA solution to copy value from multiple workbooks in the same folder.
The master workbook will contain two columns: a list of date (col A) and value (col B) copy from other workbook.
Those multiple workbooks have the same structure which contain a date (A1 cell) and number value (B1 cell)
Basically I want to perform
i) Date matching A1 value in individual work with master workbook
ii) If entry date is matched, then copy B1 value to column B in master book

It would be great if you guys can give me some advice on how to do that. many thanks!

I would help you but your requirement is not clear.

Lets say you have ten workbooks in the folder and all workbooks including the master have the date 20/12/1960 in column A. lets say A1

You are asking for the corresponding value in column B to be copied from B1 in the workbook to B1 in the Master.

So the end result that it is the value in B1 in the last workbook that is opened that is stored.

Now I doubt, that this is what you meant. So Sorry I cannot help.