Auto Filter search and then remove search data to allow a new search

Hi,
I am trying to auto filter a list (sheet1) and summarise it on Sheet2 with a macro button. The next stage I am having problems with as when I do another search (filter) the new list overfills the last list. If it is smaller result, part of the previous list is visible. Can I add to the macro so that when the button is clicked it erases all data below the start input cell and then adds the new filtered list?

I have attached a test file.

Cheers
John


Test List.xlsm

Thanks Alan,

This works well but it would be better if it deletes the rows as if the new list is smaller than the previous one it still leaves any filled coloured rows there and borders etc. Is there a way to delete the previous rows?
Cheers
John

Thanks Alan.

This works a treat. Great work and thank you.

Cheers
John