I recommend that you use Powerquery for this sorting. You can set up the powerquery to run on a set interval or by the Data > Refresh All button. It is designed to adjust the data range each time new data is added. There are youtube videos of people doing power query and it is much easier that VBA.