Batch Macro to combine all sheets and sheet names

[BRRLL99]

Hi 

I have created a batch macro which has combined all the sheets, 

in my end output I would like to have additional column from which sheet the rows are arrived.

ex: 

data	cost	Sheet Name
A8	10	Steel
D4	20	Steel
data	cost	Wood
B9	10	Wood
B10	20	Wood
new data	cost	Wood

Sample of my macro has been attached, since i have multiple sheets I would like to create this in a Batch Macro along with sheet names

[FrederikE]

Hey @BRRLL99,

You can tick the option in the macros input tool to show the file name. Then the macros output will include this. 

[BRRLL99]

rows should take sheet name 

not file name

[binu_acs · Accepted solution]

@BRRLL99 The batch macro I provided in the previous post has this field File Name, you can extract the sheet name from that field using the regex function