Script for Excel files data

I need to create a script that will sort data according to my request. It will need to recognize even and odd numbers and navigate accordingly in the coordinates to reach a conclusion. I'm in a hurry for this task, as I have 32 Excel files that need to be completed today.