How to refresh excel data and remove previous data automatically

I have to update a reporting template based on an excel sheet. How could I update excel sheets automatically and remove previous data? I can upend data by using Power Query refresh. I do not want tha...