I'm working on a workbook and need some help writting a formula. The workbook
wil have 6 sheets. Five sheets will be labeled with dates (May 31...). the
last sheet will be labeled Summary. I'm looking for a way to match a name on
the summary sheet to data that is attached to the name on the monthly sheets
and place the data in cells on the summary sheet. The name and data (not in
the same cell) will appear in the same columns of the monthly sheets but not
in the same rows.

Thanks
AJ

hello,

hint : you should have a look to the function INDIRECT which do the
job (as far as I've well understood your need).

Mat