The shortcut Ctrl+F6 is to switch to the next workbook when you have multiple open workbooks.
Step 1: Click anywhere in one worksheet;
Step 2: Press and hold the Ctrl key, then press the F6 key from the keyboard, you will switch to the next open workbook. Repeat to another one.