See if this works for you on a new workbook first
On Sheet1, in row I enter the numbers 1,2,3,4 .... up to 366 (this is in
Cell NB1)
You need enter only 1,2,3 and drag to fill the other cells
On Sheet2 (It does not matter what it is called) enter =Sheet1!A1
Click the fill handle of A1 (the small solid square in lower right cornet);
drag to CO1
This gives formulas =Sheet1A1, =Sheet1!B1...... =Sheet1!CO1
On Sheet3 (It does not matter what it is called) enter =Sheet1!CP1
Click the fill handle of A1 (the small solid square in lower right cornet);
drag to CO1
This gives formulas =Sheet1CP1, =Sheet1!CQ1...... =Sheet1!DG1

Do you see the pattern? Sheet2 show the first 93 cells of row 1 in Sheet2
Sheet3 shows cells 94 to 186

Using R1C1 formulas might make it easier to do but harder to explain!

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kev" wrote in message
...
Thanks for response, i will explain. My Excel schedule runs 366 columns on
one sheet. At the bottom of that sheet i have tabs marked sheet 2, sheet 3
sheet 4 etc. I have relabelled them 2007(the original), 2007 Q1, 2007 Q2,
2007 Q3, 2007 Q4.
I am hoping that by clicking on the now Q1 tab a sheet will appear
displaying just the first 93 columns of sheet 1(2007) and the sheet 2 tab
the
columns 94 - 186 etc?
Therefore as i input data on the 2007 sheet when i finish my not so bright
boss can click on Q3 and just see the data from columns 187 - 278 july -
sept.

I have a feeling im explaining this badly.

"Bernard Liengme" wrote:

Question is unclear.
What do you mean by 'tab' - the actual sheet's tab and you want to change
its name? or are you misusing 'tab' for 'worksheet'?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kev" wrote in message
...
Please help, I have a 365 day schedule and want tab 1 to show Q1 Jan -
March.
So any data changed on sheet one the full year will be reflected in
sheets
1
- 4 labelled Q1 - Q4?
Im sure its easy but i have really searched.
Please help me.
Kev.