You say "Any time  the current  cell changes ...". Do you mean that the
contents of the current cell  changes, or do you mean that you move the
selection to a different cell?

I'll assume that you are talking about changing the selection.

If so, you need code - not formulas. You will need to use the "worksheet
selection change" event. That event has a parameter which is the cell that
is the current selection.

Best way is to use the Intersect function to see if there is an intersection
between the current cell and a Range function call containing a
comma-separated list of your various small ranges.

If there is an intersection, then you know it's one of your wanted cells.
Simply assign the value of the active cell into the value property of M7.
Otherwise, assign an empty string.

A few Google searches will get you appropriate examples.

Note that this will only work  when the selection changes. I.e. it will not
work for the initial position of the active cell.

You say "Any time  the current  cell changes ...". Do you mean that the
contents of the current cell  changes, or do you mean that you move the
selection to a different cell?
-End-

Both. The contents of the cell will change, and I (or whoever is using the
program) will move the selection to a different cell. Googling brought me
odd suggestions, the most common suggestion I hit was a way to report the
row the selection is on, not the value of the selection itself. It is for
dates on Cemetery headstone work, meaning the range of values will be from 1
to 31.

Reporting the row means that you would use the Row property of the
selection. To report the value, use the Value property instead.

However, if you are wanting to also pick up changes to the cells  themselves,
you will need to do either of two things ...

1) Handle the worksheet's "Change" event as well. That event will get
fired when the contents of a cell  are changed. Or

2) Instead of putting the value of the source cell into M7, you can put a
formula that links M7 to the active cell. You would do this by assigning
the formula (which is simply a string) to the Formula property of M7. You
can get the address of the source cell (to put in the formula) by looking at
its Address property.