You could have a look at this post it uses R package to import CSV files with very different structures. You would still have to decide what to do with them later. I think this example would be adapted to your needs with readxl package.
And also it might help if you could provide an example most closely representing your problem (especially possible quirks that a solution must be able to overcome).