Sure here is a summary of a references and quotes I found online:

* On the Data tab, under Tools, click Consolidate. In the Function box, click the function that you want Excel to use to consolidate the data. In each source sheet, select your data, and then click Add. The file path is entered in All references.

* A visual demonstration with notes:
https://excelchamps.com/blog/merge-excel-files-one-workbook/
spam fails_task lang_mismatch pii not_appropriate hate_speech sexual_content quality toxicity humor helpfulness creativity violence