This moves the data, but it doesn’t integrate it particularly well-the data is still kept in separate sheets. Using the methods above, you can move and copy sheets between different Excel spreadsheet files.
Using The Consolidate Tool To Merge Data In Excel Together
If you have more than one Excel file, you’ll need to repeat these steps to merge them together into a single file.
