Sort data by time but have more than one row to be sorted as well

Hoping someone can suggest me something or point me in the right direction, I have a data where I need to sort by start time ( in order ascending/descending) but issue for me, some cells have data in more than 1 row which is to be sorted as well along.

Also is this something can be automated by macro, as will be working on this on daily basis to create a sheet from similar looking file format to the one which is sorted by start/finish time a nicely manner.

Current process is to refer this sheet and use a blank with pre populated (same fields data already sorted) but without name, which is added manually by looking up time & ID column etc. Process will become efficient if I can find a way to sort filter the data in itself.

I have attached a file for an example, cell highlighted in orange is to sorted and as result want cells in yellow highlight should sort along with it. My first row should show earliest start time and so on.

Sorry have not used excel for few years and now back in admin work, every step seems a challenge but will get there. Thanks for your time on this.