If you use Office2016, its own power query can be perfectly resolved, but if office2007~2013 version, you need to go to Microsoft's official website download (Download address: https://www.microsoft.com /zh-cn/download/details.aspx?id=39379).
Pull up so much to see how to use it the simplest to complete the merge work.
From the Excel data item, click Edit when you select the table you want to create from the new query-from file-from workbook, and in the Navigator, choose the multiple worksheets you want to merge. Excel Tutorials
Select Append query in the pop-up interface, select the table you want to merge, and add it to the right display box.
Finally, click "Close and upload" to complete the data merge work, very simple.
Of course, if we're just trying to query some of the data in a workbook, you can do it without merging, and select the search scope for the entire workbook, not the individual worksheets, directly in Find and options.
Two requirements two solutions, the simplest workbook merge and data query operations, you get to the point?