update master files from multiple children files

I have a file A in which a column needs to be updated daily with values from a column in file B080909. There's a new file B everyday and the name is in date format (080909).
I know i can do this with Excel/Access but im not sure how to. Can anyone guide me to the right way?
Thank you so much!!!

Hi
Can you attach a sample A & B files so that we know what you are looking for.
Ravi