That is exactly what I did. All sheets had one of two distinctive formats and I read them and joined them in two csv files.
Manually doing this however was not an option as this manual data processing is exactly what is so mind numbing and what I hate.