how to sort a sort data based on headers

See if the attached will work for you. It will take a little bit of manual adjusting when you add a new date - you will need to insert a row and copy some stuff down.

I used a helper column (N) to overcome the merged cells in B, you can hide this if you like