See
http://www.rondebruin.nl/copy2.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Pammy" wrote in message ...
I have 85 worksheets all formatted the same - 4 columns and each sheet has
different row amounts. I want to have one master spreadsheet with all the
information from the 85 worksheets. Can this be done?