I need a hand to make a macro for a worksheet when enters a date it will output a certain information from other worksheets, for example:

worksheet 1
X 11/20/2012
Y 11/21/2012
Z 11/20/2012

worksheet 2
A 11/20/2012
B 11/19/2012
C 11/20/2012


Working spreadsheet
Input : 11/20/2012

Output :
Column A
X
Z
Column B
A
C

Thanks !