Newbie question

[sagent3000]

I have 30+ execl sheets and i have been searching for a vba code in excel 2010 that will take "sheet4" from all the excel files and put them in one excel file. all the sheets are named "sheet4" also if i could set it to run from a paticiular folder that would be great too


thanks for the help

 

[sagent3000]

bump

 

[VoG]

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