Create Tabs within Excel Worksheet

It sure can be done. In fact, it is what Excel is for besides being a calculator.
You must first create all of your tabs.
Then I would suggest to select the cells you want to show and in the format window, click on the Protection tab and unlock those cells. At the same time give those cell a background color so you can tell which one they are.
After that, Select all of the cells in the tab by clicking on the corner at the upper left side of the table and change their font color to WHITE so you can't see what is written in cells. at the same time, in the protection tab, check Hide and locked.
Now, return to your cells you want to show and select an appropriate font color.
It is now time to protect your sheet. Go into the Review menu and click on Protect sheet. Make sure the case saying "Select locked cells" is unmarked. This will prevetn users to select unprotected cells.

Do the same for all of your tabs.
Hope it is clear for you.

But how to you get the switch to occur? I want the data to appear in the same area. Just that when you click in the cell that says 'Tab 1', Tab 1's data appears. When you click 'tab 2', Tabs 1's data area changes to reflect tab 2's data.

Here is what im trying to achieve: http://jqueryui.com/tabs/ Except with excel and with content being cells. Pretty much just like how you have tabbed worksheets within a workbook.

I thought the tabbed worksheets were what you were looking for. Is this a lot different?