Hundreds of sheets, trying to loop through and extract specific columns

[SamT]

See also: http://www.vbaexpress.com/kb/getarticle.php?kb_id=454

In VBA, with the use of DIR, you can open every file in a folder, then copy the data you want. Don't forget to close each opened file before opening the next