Dynamic rename excel sheet

[senselearner]

Hey Guys,

I have about 50 excel where I want to dynamically change the name of the sheet. For example

Input excel sheet name:

1 . Name of the sheet: 010 month end SSM to GL recon Jun 20

2. 011 month end SSM to GL recon Jun 20

3.  012 month end SSM to GL recon Jun 20

4.  019 month end SSM to GL recon Jun 20

Output name: SP010_JUN20_QLIK

                              SP011_JUN20_QLIK

                             SP012_JUN20_QLIK

                            SP019_JUN20_QLIK

Not looking for an entire solution. I am just looking for some sort of guidance. Any help would really appreciative