append data from How To Append Data From Multiple Excel Files 22 May, 2021 Under Macro name select MergeExcelFiles and click Run. In the Function box click the function that you want Excel to u…