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.