No I don't really have any suggestions for when the same name  appears on a
few sheets  in a row. The problem is that it is probably too late to do a
lot - it would have been nice to identify them as the same name before
sending them to the different sheets.

My feeling is that you'd be better off keeping everything in the one place
until the analysis is finished, then split it up based on that analysis.