I need help pulling data from a sheet that appears as a pivot table

[daryllc]

i have an issue that i can not find a solution to. Hope someone can help.


Sheet=

Part Oct-09 Nov-09 Dec-09 ect.....
A 102 254 102
B 254 125 963
C 102 254 102
D 254 125 963
ect...


I need to be able to have the user enter a date and pull the info associated with that date into a text file shown below.
user enters date oct-09 into a input box.
excel pulls the data for oct-09 and exports a text file below seperated by pike symboles.

A|102
B|254
C|102
D|254

see attachment for more detail.

Thanks Daryll