I want to ask after i run macro for filtering the number not start from 1 how to renumbering or auto numbering the data after filtering?

I am new to macro excel and handed the excel file , its used to work but as the data get added its not working anymore. search for year not working when insert the year all data out not the one I want to