Are your "header" rows in A3:W3 and A5:W5 etc the same as those in
A1:W1? If so, then you can apply autofilters and if one of the header
descriptions is, for example, "Surname", you can filter for this on
that column. Highlight all the rows that are displayed (except the top
one) and Edit | Delete Row. When the filter is taken off all your
duplicated header rows will have been deleted.

Hope this helps.

Pete