Hi
Your question is too vague, hence no replies. People could spend time
guessing what you want, but then you would come back and say "thanks,
but really I wanted this...and this...and maybe that over there...".
You need to be much, much more precise about what you have and how you
want it turned into what you want.
regards
Paul

On Mar 28, 4:58 am, wrote:
Hi,

I need to consolidate around 300-400 worksheet into one. All the worrk
sheet has Alphanumeric name which is random. These are typical
cashflows for each unit(with alphanumeric name in each worksheet) for
couple of years(rows). All worksheet has identical columns. what is
the best way to consolidate the data.

Thanks,
Excelhelp