Multiple files need to create summary sheet

[frets2011]

I need a macro or VBA to pull data from multiple excel files (all with same format and in the same folder) in order to create a summary file of that data, also once the data has been summarized, I need that file to do a "Save As" then clear data. Can this been done? HELP!!!!

 

[VoG]

Maybe this http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[frets2011]

A little complicated, I just need to pull one or two cells from each file into a summary file.