I have a large number of worksheets, all with the exact same format. I would
like to be able to have them all in one one worksheet, without having to
spend a large amount of time using the copy and paste functions. Therefore,
is there anyway of combining a number of worksheets within a workbook into
one worksheet, so that the data from one worksheet appears directly beneath
the next one?

See this page Steven for a VBA example
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steven Hunns" wrote in message ...
I have a large number of worksheets, all with the exact same format. I would
like to be able to have them all in one one worksheet, without having to
spend a large amount of time using the copy and paste functions. Therefore,
is there anyway of combining a number of worksheets within a workbook into
one worksheet, so that the data from one worksheet appears directly beneath
the next one?