I got the requirement to read the file with same structure from different path and different sheet, so I worked and identified a way to achieve this requirement.
Step 1: List the files that are required to read from the different path and create it Excel with the file name and respective path.
Step 2 : Create batch Macro give control parameter as filepath and mention the correct template.
Step 3 : Create a workflow add source input and Map Source file i.e. list of files with path.
Finally you can see the all the data are merged together write in your output as single file. You can additional transformation if you want process any business logic further and write in output.
Note: Adding additional file name source path will be enough for additional file processing.