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


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


"Combining spreadsheets in Excel" <Combining spreadsheets in wrote in message
...
Have several spreadsheets to be filled out by salesmen - Would like to roll
each sheet up into a master sheet leaving no blank rows. Some sheets may
have 2 rows - some may have 20 rows. Have about 20 sheets and 1 master sheet.