I really don't see the point of having all these tabs.

Surely it would be simpler to use a single worksheet with containing two columns: one for each street and the other for the suburb, with autofilters on each, so the users can choose all streets for one or more suburbs, or all suburbs with the same street name?

If someone needs to add a new street, that can be done anywhere, by inserting a new row with the suburb & name data, even when the filters are on.

See attached demo using US States & Locales. Even a novice will soon learn to use the filters.

Attached Files

Filters.xlsx (71.4 KB, 11 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]