
I've three excel a,xlsx,b,xlsx,c,xlsx each of these excel has one sheet named as A, B, C and I need to combine these three excel and named it as d.xlsx contains sheet name A,B,C in it how to perform this in power automate desktop.
I have a PAD/macro combination for combining excel sheets with the same column set here:
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Entering-the-data-from-more-than-1-excel-files-in-to-sql-server/m-p/1256194#M6602
Good luck!