This particular issue is a comparison of sorts...I want a column of formulas
to change with the month referenced in another cell.

I have a "now()" function formatted to show a two-digit number for the
month. I have 12 columns with month headings (Jan, Feb, etc.); underneath the
month headings, I'll store the reconciled quantities that get compared to the
current quantities (if the change between the current & reconciled quantities
is greater than 10%, a format change occurs & the cell displays the lower of
the two quantities). I have a list of what could be hundreds of items with a
corresponding current quantity. I want to reconcile between the current
quantity & the reconciled quantity each month but I want to keep the history
of the reconciled quantities too. I'm envisioning a column with formulas that
reference the now() function & pull in the appropriate value from the columns
with current month's reconcile data.

Basically, if month = 02, use reconciledata from column Feb for specific
item (continue to fill this formula for all items; change each month)