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.
I think some where in calculation a serial number is adding for each sheet name. If you observe the pattern in sheet names it is adding 1,2,3,4 at the end of each sheet name. So check your logic once again.
If you can share xaml file that would be easy to assess and find out the mistake.