Macro to make a cum list
 

I have a number of xl files located in the same folder. I would like to have
a macro which runs through the files, finds the name from B1, copies it to
cum list and cums all the codes from the sheets which has this name on. Also
this macro should populate data only from files which have the date matching
into given time interval in B2.
A B C D
1 name
2 code date
3 A
4 B
5 C
6 D
7 E
8

It should appear something like below assuming there were 3 of code A, 0 of
code B, 2 of code C, 5 of code D and 1 of code E found from files having
name1 on.
1 2 3 4 5 6
A code A B C D E
B name1 3 0 2 5 1
C name2
D name3
E name4

Great thanks for every reply
--
Regards,
veljo