I have a workbook with over 100 tabs... the tabs are identical other than the date and the data within... for example there is a sheet/tab for 2-2-2012, another for 2-3-2012, and so forth.

I want to run a macro that would go through each sheet and copy specific cells to a new "summary sheet"

The data in each individual sheet looks like this (in columns D, E, and F):

DATE TYPE AMOUNT

2-1-2012 X $2,492
2-1-2012 Y $4,102

Then the next sheet would look the same:

DATE TYPE AMOUNT

2-2-2012 X $1,494
2-2-2012 Y $3,104


I want to run a macro to produce a summary sheet that looks like this:

2-1-2012 X $2,492
2-1-2012 Y $4,102
2-2-2012 X $1,494
2-2-2012 Y $3,104

and so on

Any help with syntax would be great. I tried to record a macro but couldn't get it to work for more than one sheet.

I think my psuedo-code would be something like:

for each sheet in workbook,
copy cells D1, D2, E1, E2, F1, F2
to the next available row in a sheet called 'SUMMARY'


Appreciate any insight