I would like to input monthly data in a cell, lets say Cell A1

Within the spreadsheet I have a set of monthly figures, lets say from Cells
M1 through to M12 (Jan to Dec)

If state that Cell M1 = $A$1 and drag that down to M12.

Is there a formula to automatically junp to Cell M2 etc when I input data
into Cell A1 each month?

Thank you for your expertise.

Cheers, Peter