Hi Nicolas and welcome to the Community!
Yes, it is possible. You will need to use a loop, or as we call it, iterations. It works as follows:
- Create a module (A) that imports one range which name is specified using a parameter.
- Create another module (B) that lists all ranges using the “Excel command” action.
- Use the “Iterate” action in module B to run module A as many times as there are ranges. In each iteration, pass a range name to module A by assigning its parameter.
This topic has a bit more complex scenario than just loading multiple ranges, but it has detailed explanations and examples: Multiple files, small variation in sheet name, import with parameter