select all the sheet
then go to data and remove duplicate
by this way, it will remove only rows which
are identical
try it now, it will work
thanks