You need more detail

1) Describe each page in more detail. It appearrs you have a row with just
JAN and the next row with data. then a row with just FEB and another row of
data

2) How do you want the Summary to look. Describe column and rows.

"Migyu" wrote:

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.