Hi, I am reading and writing the data in the new workbook. where I am reading the data from the multiple excel files where the sheet names are dynamic, I am reading the dynamic sheet name and writing into the new workbook with the same sheename. I got the sheet name but it’s comes with extra content.
below is my sheet name from where I reading the data.
These are my sheets name from where where I reading the data
And after consolidate what I am getting in the below screenshot.