How to Import Data From Multiple Spreadsheets

1. Open a new blank workbook. Begin the installation process by clicking the 'file' tab and selecting 'Options.' Select 'Customize Ribbon' in the 'Excel Options' dialog.
2. Select 'All Commands' in the 'Choose commands from:' drop-down menu. In the left-hand pane, select 'Compare and Merge Workbooks' and click 'Add.' You will be given the option of which ribbon you want to place the new function. Click 'OK.'
3. Put all of the worksheets and workbooks you want to merge into one folder in your hard drive. Locate the 'Compare and Merge Workbooks' function, which will have been saved in the ribbon of your choosing. Click it, and then select which workbooks you want to merge.