How to copy autofilter data

Can someone please tell me how I tell excel 2003 to display the value selected from an autofilter list into another cell, be it on the same sheet or another sheet?
I have a dummy workbook. On sheet1, I would like cell A3, B3, C3, D3, E3, to display the value selected from their respective list. Any help would be greatly appreciated. Thanks Mikal. (It's only easy if you know how!)

A B C D E F G H
1
2
3
4 U S G Y E1 E M SC
5 1 AB M N B 1.32.07.777