Hi

I'm pretty new to macros hence please bear with me.
I receive 20 excel workbooks every day and are placed on to one folder. I
need to copy the data from a specific sheet and specific range from all
sheets in the folder and create a summary file. How to create a macro for
this?
Note : the folder in which these files go in to chnages everyday meaning to
say for every day there is a new folder created

Regards
Siddharth