Try this Mike

http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message ...
I have from 2 to 5 worksheets that I need to merge. Eack sheet will contain
column titles in row 1. Each sheet will contain data in columns A-O. The
number of rows is variable and there are no named ranges. The columns will
always be in the same order.

Is there a simplw way to do this? How do I find the range of data on each
sheet?

Thanks
Mike