A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Try control + Shift + tab.
It could be bug that control + tab only switch the last two files. You may also Send feedback to Microsoft with the Feedback Hub app - Microsoft Support.