progessing sheets in columns

Hello, I am attempting to fill a column with the following formula, with the sheet name progressing by 1 each time.  ='G1'!$K$24 in cell 1, ='G2'!$K$24 in cell 2, ='G3'!$K$24 etc.. However it does n...