I have a complex sheets. 4 separate sheets in fact. Each sheet has a data for
12 months by ( months) for four separate product. each month there a macro
to copy data from these four separate sheet and compile into one. Your help
is much appreciated.

here is an example
JAN
RanK pdt# Account # Revenue
FEB
RanK pdt# Account # Revenue

All four sheets are in same format.