Loop through folder, open each file, copy/paste into master worksheet, close each file

Hi,
I've recently been figuring out how to automate some of my stuff using macros and now I'm stuck with the last step I need to complete. Currently I have my macro needs broken down into 3 parts (I'm sure I could do all of this in 1 macro, but I'm not that fancy and I'm fine keeping it the way it is). Here's what I have.

Macro 1: turns raw data file into useable file and saves it.
Macro 2: loops through a folder to complete Macro 1. (all data files now look identical, but have different workbook names and different worksheet names from each other (only 1 sheet per workbook)).
Macro 3: loops through same folder to copy data from all files (100+) to master workbook.

I'm stuck on Macro 3 and can't figure out how to do it. The way I have it right now, Macro 3 is stored in the master workbook. If it should be/is easier to be somewhere else, please let me know!

The master workbook is a .xlsm file. Each data file is a .csv file.

I have my master workbook and the sheet that I want all of the copied/pasted data to appear on. This master file is not in the same folder as the files that have the data (the data files are 2 levels deeper in subfolders if that matters). Each file that needs to be copied has data in A1:AP101. I need A2:AP101 copied from each file and pasted in the master worksheet. Each file needs to be pasted on the next available row.

Attached is a sample file of data.

Below is the code I have attempted to use from davesexcel:

Please Login or Register  to view this content.

What happens when I use this code is basically nothing. I can see Excel working like it's trying to copy/paste the data, but nothing is copied into the master worksheet. The macro is completed without any errors, however, so I'm not sure what's happening or where things are getting lost.

Any help is appreciated!!

Edit the line

Please Login or Register  to view this content.

to include a '.' before Range

Please Login or Register  to view this content.

Hi cytop,
This worked perfectly, thank you so much!!

Originally Posted by Marc L

[INDENT]
Or rather than useless variables just directly copy the range !

This didn't do anything for me, but I'm not sure why. Excel looked like it was working again but nothing pasted into the master worksheet. The suggestion above from cytop did work, so I'm going with that for now. But I'd be happy to try yours again; I just don't have the knowledge to know where it's going wrong.

As it well works on my side …

Thanks for the rep' !