Query for a folder results in a null

Power Query
1

*** READ FIRST ***
I have a folder with identical worksheets, these are templates mailed to 9 different
entities and received by the end of the month. The only difference is there are 5 in the french language and 4 in the Dutch language
I only need the yellow ranges as I have a related table with the names for the numbers in column B. The headers can I enter as a final step . This will be the french - dutch header → example Criées - Veiling.

as you will see in the query from folder .xlsx the numbers are null for the second file
this is the case for all the files in on of the languages.

I have no clue what is causing this error.

any help is greatly appreciated
kind regards
roger

2024 01 BAB.xlsx.xlsx (16.0 KB)
2024 01 BAC.xlsx.xlsx (17.1 KB)
query from folder.xlsx (25.8 KB)

2

I found a solution in creating a name on the sheet data
the name has to be an absolute reference and this one is picked up
by power query
If a assign a name using the offset() then power query doesn’t recognize the name !
curious why that is any suggestions?

kind regards

Roger