Yes DELEV-A/DELEV-B are sheets on those files. there are only 1 sheet per file. you can follow this thread of mine.

The files you have in test1.zip attached to your message here: https://www.msofficeforums.com/175882-post1.html
which have names like 01-02-23-BB.xlsx
are not raw data - there are formulae in them, and the results of these formulae seem to be used in the SUMIF formulae of your

I would like to see some untouched raw data files; there must be some somewhere (perhaps they're .csv or .txt files or something else?). This is so that we can let the query/queries do the necessary transformations instead of going through 2, 3 or more intermediary files, all of which, as you've seen, can introduce errors, and what's more, these make a lot of work for you to maintain all of them.

that data is kind of "raw data" for me. i dont make those. Each month those delivered to me that way, all 56-62 of them. so changing to database type is another hurdle. this is what im working with. if improvement not possible, i'll make do with what i got.