on each worksheet insert a new column A and put worksheet name in cell
A1 and copy this right down.

Take worksheet name1 and copy it to a new sheet, sheetnew.

now take worksheet name2 and copy the data, not the headings, to
sheetnew.

copy all of them

now analyse with pivot table or sumproduct table(s)


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=557962