Naming Output tabs based on daily change to data

[Rob48]

Hello, I run a workflow daily that feeds 4 separate tabs into an existing excel output file.  Each of the tabs has the same format and the last column in each tab will have a different output and that day's date, as below:

Tab 1	Tab 2	Tab 3	Tab 4
Last Column Name	Last Column Name	Last Column Name	Last Column Name
ABCD 22May	EFGH 22May	IJKL 22May	MNOP 22May
ABCD 22May	EFGH 22May	IJKL 22May	MNOP 22May
ABCD 22May	EFGH 22May	IJKL 22May	MNOP 22May
ABCD 22May	EFGH 22May	IJKL 22May	MNOP 22May
ABCD 22May	EFGH 22May	IJKL 22May	MNOP 22May
ABCD 22May	EFGH 22May	IJKL 22May	MNOP 22May

I want to set up the flow so that the 4 new tabs I send into the output file are named "ABCD 22May" "EFGH 22May" etc.  

Right now I'm doing this manually by selecting "Create New Sheet" in the output options in the output data configuration box, and then in the "Write to File or Database" section I manually changing the name of the existing tabs from the previous day's tab names to the new name I want.  Meaning, I will change the existing tab named "ABCD 21May" in the output file to "ABCD 22May"

How do I get my new tabs to name themselves automatically?

Thanks for any help you can provide.

[binu_acs · Accepted solution]

@Rob48 One way of doing this 

[Rob48 · Accepted solution]

thanks, that worked!

[kauser]

@binu_acs 

this solution is very helpful for me and i am able to create new tab with new name. now i am having issue to add data in this new tab. for example can you show me how to add data into this new tab to a specific cell. i mean if i want to add a data into Cell B10 to this new tab 

[binu_acs]

@kauser you need to specify the range along with path