Function to lookup date on tab in excel and populate date on calen
 

I have created a workbook with a tab for each month. These tabs have various
columns with dates (move in date-column C) followed by columns for a
follow-up date as well as dates 30, 90 and 180 days out from the move in
date. I would like to know if there is any way to populate a calendar in
Excel (the first tab in the workbook) with the resident's name and apt number
which are concatenated in column AA. I would be happy to e-mail my
spreadsheet if that would be helpful.