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