Giant excel document, wondering if there's a way to bulk-convert sheets in the format that it is or not

In the past I have been able to extract data and reformat it to a useful database with FileMaker Pro. If needed you can export the organized data again in Excell format.

Just my 2 cents.

Rogier