you can use this Loading Multiple Excel sheets for your reference.
steps for Qlik Sense :
1. you create data connection to your excel
2. creating script for loop the excel.
3. insert script load from excel.
I do not really understand what problem you are facing, can you please elaborate?
- Do you get an error?
- Is the data not loaded accurately?
- Do you get a synthetic key?
A sample of the script and data load log would perhaps help to understand what issue you are facing. A sample QVF would also be good as supporting material.
Note, I moved this thread to the Qlik Sense section of community.