Jan 17, 2020 07:51 AM|Yang Shen|LINK
Can only give you some ideas since there's actually
a charging tool which meets the requirement perfectly.
First, you will need to read multiple excel files which i will suggest the Microsoft.Office.Interop.Excel in c#.
Then, read the sheet content one by one and write the content data to another sheet in a new excel file, also with the Microsoft.Office.Interop.Excel.
You can take this as a reference but some part of code need to be updated since it's exporting into multiple sheets in a same excel file.