VBA help importing survey data into Master file

[mfthomps41]

Hi. I am wondering if anyone can help me with a macro to import data from multiple (around 500) files that all reside in the same folder, into a single master file.

I would want the following to take place.
1. open first data file (A.xlsx) and copy the survey data (A2:D20).
2. paste the copied data into the Master file (Master.xlsx).
3. close the data file.
4. repeat, opening the remaining files and pasting the corresponding data into the next open rows.

One thing to mention is that each file may have a different number of records, so file A may have 10 lines (A2:D12), and file B may have only 5 (A2:D7).

I am sure this is a pretty simple macro, but I am new to VBA and am lost. Any help is much appreciated. Thanks!

 

[mfthomps41]

Any way to post that so I can copy the whole thing, like the code above. This cuts off and I would have to copy all separate.

I have to leave the office to catch a train. I will check your response when I get home in about an hour.

Thanks so much for all of your help so far!

 

[mfthomps41]

That last one you posted I think did it. Seems to work perfect now. Thanks so much!

 

[RSXchin]

Hooray!!! Let me know the next time I can try my hand... so to speak.