Excel tabs together

Question

Hi,

How do I bring different tabs into one sheet. I have got the tab names as a template and also using the dynamic input but it does not bring all the tabs. In the attached see the workflow " excel tabs together ".

Please let me know what am i doing incorrect.

Community discussion temporary transfer.yxzp

Swathi · Answer

Here is the combined file.

As expected, All your tabs have a different schema to follow which needs a macro to be used. I have attached the combined file for all the sheets you need.

Please take a look at the workflows for future reference.

Please mark it as a solution if it helped.

combinetabswithdifferentschema.yxmc

Macro_fileoutput.yxmc

combinedfile.xlsx

Thiviya · Answer

Here you go .

From this attachment I only need the following tabs details together :

CoalBulkEA-NSWBulkEA-VICNIMCoal-QLDWilmarMt Isa Line

Payroll Support Register - Temporary Transfers.xlsx

Swathi · Answer

Could you please share the sample file alone instead. Please check with the column Names usually thats the common reason why your tabs wont combine properly