Consolidate

Hello. I have a workbook that has 50+ sheets, all the same format. Is
there a way I can consolidate the data on all sheets into 1? Basically if I
were to do it manually, I would simply copy the data form one sheet, and
paste it under the others. No math or summing, etc.

Thanks!

Try this Steph
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steph" <[email protected]> wrote in message news:[email protected]...
> Hello. I have a workbook that has 50+ sheets, all the same format. Is
> there a way I can consolidate the data on all sheets into 1? Basically if I
> were to do it manually, I would simply copy the data form one sheet, and
> paste it under the others. No math or summing, etc.
>
> Thanks!
>
>