https://cran.r-project.org/web/packages/xlcutter/index.html
CRAN: Package xlcutter
Parse entire folders of non-rectangular 'xlsx' files into a single rectangular and tidy 'data.frame' based on a custom template file defining the column names...
cranpackage