Hello all, I am a pretty experienced macro writer, having spent about
40 hours last year writing a macro in Visual Basic. I find myself
with just about the same need now and I want to confirm that the macro
is the best way to go.

We have about 4 financial reports we need to create that are all
formatted very differently, but they all pretty much use the same
source data. Each monthly report can be created using the source data
from another. Should I just create 4 different macros that each copy
from one report to another? Or is there a better method out there
than a macro? Most reports are pretty small in size (less than 1 MB)
and have no more than 12 tabs. Thanks!