I would like to create a macro that adds up the sheets of similar excel
workbooks and put the results in a new workbook.

I have a folder that contains the workbooks all with similar names for
example m0507100.xls (for may 2007 and 100 is company identifier). Each of
these workbooks have the same number of sheets and same sheet names.

I want to add the values of all respective cells in all workbooks in the
folder and put them in a new workbook with identical sheet names as the
workbooks that are added up.

I'm new to programming so I would appreciate any help with this problem. I
use excel 2003.