Hi

I have 3 excel sheets within the same file and the header information in all
the three excel sheets are the same. I need a macro to create a new sheet
that will have the sum of the data that is available in the 3 sheets, I want
the macro to be dynamic. That is, even if i include an additional sheet, the
macro should be able to sum that data as well. For instance

If I have 3 sheets then the consolidation should happen in the 4th sheet. If
I have 4 sheets, then the consolidation should happen in the 5th sheet and so
on.

Please let me know if this is possible


--
Prem