Question: how to insert data from multiple excel spreadsheets to one excel spreadsheet?
Answer: Select Desired Data Click the first cell in the first spreadsheet to be merged, and then drag the cursor over all cells to merge. The reference is updated with the selected cells in the Reference field of the Consolidate Data dialog box.