I wish to extract data from several workbooks that are created every day.
The daily workbooks have a common eliment in their file names Eg.
On the 1st of june the file names would be :-
ABC 010607
def 010607
on the 2nd of june the file names would be:-
ABC 020607
def 020607
I wish to create ao spread sheet that I cancreate the file name:-

ABC+"010607"
def+"010607"
The next day I would just have to update the +"******"