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

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


"Steph" wrote in message ...
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!