How to Merge Data From Several Excel Workbooks

1. Click the Microsoft Office button on the screen's top-left corner, and select 'Excel options.'
2. Under 'Customize,' click 'All Commands' in the 'Choose commands from' list.
3. Check the box next to 'Compare and Merge Workbooks.' Click 'Add,' and then click 'OK.' The 'Compare and Merge Workbooks' icon will now appear in the quick access bar at the top of the window,
4. Move all workbooks to a single folder. If they share a name, rename them as necessary.
5. Open one workbook. Click the 'Compare and Merge Workbooks' icon.
6. Select the other workbooks whose date you want to merge. To select multiple workbooks, press the 'control' or 'shift' keys as you select them.
7. Click 'OK.'