May be I do not understand your final objective ...

But can't you, from the master list
one master list of every zip code in the US
add a vlookup() function to "bring back" whatever info you need ?

HTH
Carim