As it is not possible in current Excel versions to get tabs in multiple rows, I would recommend the same solution that yoavdothan did.
But here's another solution, if you want to tinker and have free space in your sheets:
Make a hyperlink to Sheet2 (select Place in this document from left, select sheet you want this link to open and so on) to cell B65535, and link to Sheet3 to cell C65535 and so on.
After adding links, split screen so that you can see hyperlinks while using your worksheet.
Copy hyperlinks to other sheets. Remember to add link to Sheet1
Downside of this one is that if you use also many columns, hyperlinks will not be shown on screen when it has been scrolled to right and you can't add another horizontal split to your sheets.