My sheets are named TM1, TM2, TM3 etc. to TM100

My formula reads ='TM1'!S$46

How can I drag the formula down so the subsequent formulas read....

='TM2'!S$46
='TM3'!S$46
etc.

Thanks