Referencing subsequent sheets by copying to subsequent columns

I’ve entered a formula into an excel column that I want replicated to subsequent columns within that same sheet, with each column referencing a subsequent sheet in my workbook. For example, Column E references to Sheet 2 with this formula: E5='2-3'!$M$2, E6=’2-3’!$M$3, E7=’2-3’!$M$4, etc. Column F needs to reference to Sheet 3 with the same formula: F5=‘2-4’!$M$2, F6=’2-4’$M$3, F7=‘2-4’!$M$4 and so on. The only way I have found to do this is by dragging the column and changing each cell manually to reference the next sheet in my workbook. Any suggestions on making this easier would be greatly appreciated.