Mike?,

If your sheet tabs are always three digit numbers, you could use, for example, this formula, entered
into a cell I5:

=INDIRECT(TEXT(ROW()-ROW($I$4),"000") & "!$I$46")

Note that the cell reference (in this case $I$4) needs to be from the row just above the first
instance of the formula.

HTH,
Bernie
MS Excel MVP


"MG" wrote in message
...
How can I change the tab but keep the row and column constant when filling in
equations?

I'm orgainizing a excel spreadsheet in which I have many sheets/tabs in.
I'm trying to put a formula in on my main page where I can get the data from
many different sheets while keeping my column and row constant on each page.
I'm trying to do this so I can drag this down and it will automatically
switch pages and while keeping column and roc constant. Example, my main
tab/sheet is labeled "MIKE" and I want to put information from many different
tabs/sheets in column "I" on the main page. Right now I've got the formula
='001'!$l$46...and when I drag it down I want it to pick up sheet '002'!$l$46
for the next line, '003'!$l$46 for the line after...etc. Is there anyway I
can do that?? If someone could help me out I'd greatly appreciate.