When you want to consolidate data from multiple Excel files into one workbook, you can easily do so using "Power Query." Click the "Data" tab -> "Get Data" -> "From File" -> "From Folder." Select the ...