how to compile one row from multiple excel tabs in alteryx

[Xenax]

Hi,

I am beginner of Alteryx user, now I am stucking on how to compile one row from multiple excel tabs in alteryx automation, for example, now I have 3 months tabs in excel, I want to compile each tab A28 to E28 and import into another excel tab b14 to e18, next month I will have 4 month tabs and compile 4 tabs A28 to E28 into another same excel tabs with extra rows. Anyone could help me with it. Thanks.

[ntakeda · Accepted solution]

If the format of all sheets in the Excel file is uniform, the Dynamic Input tool can be used to retrieve data from multiple sheets.
However, since the formats are not consistent, a macro is used to retrieve all records.
I have created a sample workflow. Please review the attached file for details.

[Xenax]

thanks for the help, I modify a bit and it worked for me.