Try this Jeff
http://www.rondebruin.nl/copy3.htm

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



"Jeff224" wrote in message ...
I need to merge about 75 worksheets into one spreadsheet on a regular basis -
all have exactly the same format/layout etc back can vary in the number of
rows