Hi I hope I can explain this easily without confusion. I have 12 sheets
each representing the months of the year ie Jan,Feb, Mar etc. Then I have a
summary sheet called Summary which I want to be able to display certain
values from one of the 12 sheets. The deciding factor will be based on what
month the current date is. I use the TODAY() function and a CHOOSE function
to display the name of the month in 3 letters in my summary sheet. Then I
want to be able to incorporate the name of the month in my formula so that I
can grab various pieces of info for the sheet that has the tab of the same
month. My problem is I use the following formula:

=IF(Apr!D14<=TODAY(),Apr!D14,"")

My problem is how do I build a function that will be able to take the 3
letter month on the summary page, concatenate the ! and the D14 so that the
above formula grabs the data on sheet Apr cell D14? Understand in using
this formula I need to be able to copy the formula when I am done so that I
can place it in 50 rows on the summary sheet.

Thank you in advance,

Les

ps Lets not complicate it to much <S.