How do I sort multiple excel workbooks at once?

Question

Hi,

I have 10+ excel files with same formatting that I need to sort by the first row in ascending order (see example below). Is there a way I can automate this? It's not practical for me to go into every file and sort. I am also not interested in consolidating data into one workbook with several sheets. I need them to stay as separate files. Thanks!