Hi guys

I'm looking to drag a formula down a column but only want the worksheet name to change, any idea how to do this?

I'm looking for the formula to do this:

='1'!M1
='2'!M1
='3'!M1

etc...