We had a recent discussion about this. Here is an example where you would identify tables by a keyword and then import them. You might have adapt that to your current format and see if there are regularities in the data that you can identify and use.
@ipazin is refering to the possibility of creating Excel-Tables with the help of Python.