To add a query in a 2016 Excel spreadsheet, click the Data tab, then click the drop down for New Query command.
This will open a display box that allows you to choose the workbook you want to run the query against, and will then open another dialog box that allows you to choose the worksheet from that workbook.
Once selected, click the Load button. This will load the information into a new worksheet. A navigation pane will open and allow you to refresh the information when necessary.
For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!