hi Robin

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

Or a formula example
http://www.rondebruin.nl/summary.htm


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



"Robin" wrote in message ...
I need to combine sheets on one workbook into ONE sheet, data/columns are the
same on each sheet, but original person put it different names on each sheet
instead of on one..

anyway to do that easily short of cutting and pasting from each individual
sheet?