I have a spreadsheet with same income/expense line items (rows) for each of
the 12 months. Each sheet has the same row line items and each sheet has the
same 12 columns for months. I have 3 years of data : 2007, 2008, and 2009.
Each year is its own sheet. I want to make a summary sheet where a month/year
is entered and 3 columns are displayed: the same line items for month A 2009
adjacent to the same line items for month A 2008, and the same line items for
month A 2007.

Since sheet name and row are set the only real variable is month. I can
compute the column portion of cell address by using char(65) + month(selected
month/year) but what I get is a cell whose contents are the computed address
rather than the contents of the computed cell address. I tried using
cell("contents", with computed address but I just get errors). Am I
violating an Excel law by computing a cell address and trying to load the
contents of that cell into the same cell where the address was computed?
Does this require a macro? Our local expert is stumped.

Office 2007 Excel Vista