What are you joining the fields on- that is probably where your issue lies.
Also. If the data is in the same format across all the sheets- A union is what you want to do
I joined the files on ‘Outer’ and the data are in the same format across all the sheets.
What will the ‘union’ do ?