Combine Excel Worksheets Into One Worksheet. Copy sheets in each workbook to one sheet. We must first create a new worksheet and name it a “consolidated sheet.
In the step 2 of 3. Id (dynamic content from list files in folder) script: Web consolidating data is a useful way to combine data from different sources into one report.