Start here
http://www.rondebruin.nl/copy2.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Steph" wrote in message ...
Hi. I have a workbook that has 80 sheets. Is there a way to copy column A
from every sheet and paste it one under the other into Sheet1? Thanks!