Copy data from many workbook and consolidate it to one workbook

[isay]

Hi Experts,

I have masterCopy.xls that contain all data that I copy from many workbook with specific date range. These documents are all in the same directory.
Example:
From xls1, xls2 and xls3, I will copy data from Date 08/01 - 08/05 to my masterCopy.xls.

I need your expertise on how I will automate these manual procedure. Through researching, I found out that there are ways to copy data from different workbook and consolidate it to one workbook. I'am still researching for this and I know you guys have more to share.

Thanks in advance.

 

[VoG]

This may help you get started http://msdn.microsoft.com/en-us/library/cc837974.aspx