We have a requirement to combine multiple workbooks and generate pdf, and the sheet name can be same for multiple worksheets. We try to combine multiple workbooks using "Workbook.combine" method, but if the same sheet name causes the data reference issue. Can you please advise?
Workbook workbook1 = Input, cover (Sheet Name)
Workbook workbook2 = Input, Product, Term1, Term2 (Sheet Name)
When we try to combine the above two work books, but workbook2 losses the reference of the sheet name "Input"
Thanks & Regards,