text: in excel how can i refer in one sheet to all the other sheets without typing the name of each sheet? i refered to one cell of the first sheet and then drag but instead of changing the sheet number it changes the cell number. example a1= 'sheet 1'!a1 b1='sheet 2'!a1 ........... instead of  a!='sheet 1'!a1 b1='sheet 1'!a2 use this combination, in a1 then fill down =indirect( address( 1,1,,,"sheet"&row() )) now this will work perfect, if your sheets are named in this mask "sheetx". if you have another sheet names mask, or want more details, mail me here in y! answers.  enjoy my profile, i am the vbaxlman