When you have opened so many workbooks in excel and want to move from
one workbook to another please follow below mentioned steps.
To switch from book1 (1st excel file), Book2 (2nd
Excel File), Book3 (3rd Excel File)
1- Open all excel File.
2- Select “View” from Menu bar then select “Switch Windows” Option. Also we can use shortcut "Alt+W+W" for speedy work
From this way, we can switch from Book1 to Book2 and book3