text: Use this combination, in A1 then fill down\n=INDIRECT( ADDRESS( 1,1,,,"Sheet"&ROW() ))\nNow this will work perfect, if your sheets are named in this mask "SheetX".\nIf you have another sheet names mask, or want more details, mail me here in Y! Answers.\n\nEnjoy my profile, I am the VBAXLMan