Using name manager

[Klartigue]

Please see the attached excel sheet. I would like to be able to have cell B6 on Sheet1 essentially embedded with all the zipcodes for every sheet in this workbook (so the zipcodes in column F of sheets January2006 and February 2006). So then when I begin typing a zipcode in cell B6 on sheet 1, a drop down menu essentially appears and I can pick exactly which zipcode I want.

Is there a good way to do this off the top of your head?

[Kenneth Hobs]

This takes a bit of work which is why you have not received a response. Would you want those sorted and duplicates removed?

[Klartigue]

As in the drop down menu? Yes, they can be sorted and duplicates removed. My goal is to enter a zipcode, and have every row from the sheets with that zip code copied and pasted into another sheet.

My goal is to search many sheets for the same zipcode, and do this wihout having to manually go in and filter each sheet