Import Multiple Excel Workbooks & Multiple Sheets

[#1]

Do you have Multiple Excel Files each containing Multiple Sheets that needs to go through Routine Calculation/Formula Steps?                                      OR

Do you have to manually replace the Excel Files given as Input to Alteryx Workflows?

Then here is an Alteryx Workflow/Macro which will let you import Multiple Excel Workbooks containing multiple Sheets, Apply the required Calculations on each sheet and then Save the Output in same the way as it was provided as Input with same Sheet/Tab Name.

(Note: Output Excel Workbook Name is different to identify Input & Output File easily.)
(Note: Add/Modify the Calculations/Formula in 2nd Macro as per your Data Requirements)

Open to Feedback

This is just a Starting Point. Edit the Workflow as per your Data Requirements

Spoiler

[allwynthomas24]

Thanks for the like @LeandroYgorLoli ... 

[allwynthomas24]

Thanks for your Like & Support @BRahuL99 , @Edgar_Padilla, @Pawel_Paleczny 

[jkmahesh13]

Hi Team

I have Various input files in below format, where i have bring specific values in cell in the output and it should contains data from all the files

File format in xlxs is give below

Recon
Fund: Abc New1	Reporting On: Only
Report Generated Date: 1/22/2024
123.XLS -ABC
2024011.csv  -  ABC
90124.xls  -  Abc
17111.CSV  -  ABC
	Value	External File Value (T1)	Difference (T1)	Bp Difference (T1)
Total Portfolio Value:	123.00	234.00	111.00	-0.22
	Total Breaks	Total abc Breaks	Total abc tds Breaks	Total HOLD Breaks
Summary of Breaks:	15	0	0	11

I need to get output given below, kindly advise an Alteryx workflow where this runs with multiple input files with same format give above

1	2	5	6	7	Input_#16_1	11	Input_#18_12	9	Input_#20_10
Fund: Abc New1	Report Generated Date: 01/22/2024	123.XLS  -  ABC	2024011.csv  -  ABC	90124.xls  -  Abc	Reporting On:  Only	Total Abc tds Breaks	0	Bp Difference (T1)	-0.22

[sylvia0218]

Thank you for sharing this macro!