Working with Multiple Workbooks
When you create an Excel workbook for each subject of your business, you will sometimes need to look at data from more than one workbook to make your decisions. In cases like this, you can switch between them by choosing the workbook’s name from the list displayed when you click the Switch Windows button on the View tab, or you can choose one of several arrangements so that you can work with your workbooks effectively.
Switch between Open Workbooks
Click the View tab.
Click Switch Windows.
Click the name of the workbook ...