Tabs Inside of a worksheet

[havocdragon]

Hello all.

This is a shot in the dark, and I'll see if I can explain what I am talking
about =).
I wan't to add some tab functinality to a range of cells, so that lets say I
have 10 sources of info but I dont want it to take up 2 pages thats hard to
read, but it still needs to be in the middle of some information. So lets say
I have A10 through J20 that has infomation in it on one tab, then I would
like to click another tab, and have A10 through J20 to display some different
information. Basically the samething as the sheet tabs, but within a small
range instead of a workbook.

Is this possible? Or have I smoked too much crack this time?

 

[LanceB]

Looking through the smoke from the crack, it appears you might want to look
at pivot tables, but I'm not sure, crack being what iit is.

Lance

 

[havocdragon]

LanceB, Unfortuneatly a pivot table requires a pre existing source of
information in the form of a databse. What im looking for would be for manual
design and inputs.