I have a an automation issue for which request your kind support and guidance.
I have 2 sheets in an excel file, all have 2 records each and there are 2 columns which are same.
I would like to copy the records from all the sheets in a new sheet. In the 3rd column, i would like to add the sheet name for whom the record belongs.
I could get all the records in one sheet, however I am unable to get the sheet name copied against their respective records.
An example is highlighted in the below screenshot where i could copy the data from both the sheets, however, sheet name is not coming.
Request your assistance on the same.