Macro needed to clear contents

Hello All
On the attached worksheet i have 2 columns of data sorted sequentally in cols A&C,in col AN i have related data.I wish to use only the last 5 or less sets of data for each name from the most recent date,if possible using a macro to clear the unwanted data.the worksheet is much longer than that shown.On sheet 1 have highlighted the data to be removed and left empty rows between the data for illustration only.Sheet 2 shows the desired result.Many thanks for help given.