Loop to open all workbooks in folder and append data to single sheet

Considering all the complex tasks I have learned on this site, I am a little embarrassed I can't figure this one out. As stated in title, I have a folder full of workbooks that I need to simply open, copy data, paste to the main workbook, and move on to the next workbook. I can handle all the cutting and pasting commands fine, but the looping has me stymied.

I have tried a few approaches like trying to use the

Please Login or Register  to view this content.

and stealing from past loop codes that I have written that actually worked

Please Login or Register  to view this content.

but I can't seem to figure out a way to do what sounds like such a simple task!

Any help would be very much appreciated!

That worked fantastically well! The size of what I want to copy can change, so I put in a large range and added a clean-up line to remove blank rows. Also, if the "update links" popup is bothering anyone, it can be disabled in excel's option menu.

Please Login or Register  to view this content.

Thank you for the quick help!