I would go about first building a master sheet that has all the names of
the streets, then on the susequent sheets where the information is to be
pulled from have the exact same names and then do a vlookup run by a
macro from the master sheet to pull whatever data you need.

I hope this works.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!