You can use a for each excel sheet activity. And then perform your action within the given for loop.
enter image description here
Alternatively you can also use only code within an assign to get all. sheet names, add them to an array, and then iterate through the array.