Hello,
I'm a consultant working for a city. I have a Workbook spreadsheet (Tab) that contains parcel data for this city, such as parcel number, StreetName, house number, full address, zoning category, etc. I've sorted the data StreetName thereby grouping all of 1st Street, 2nd Street, Smith St, etc. My first tab is set up to show all streets, grouped/sorted by StreetNames. This tab is called All_Streets



I need to display data for each separate Street on a separate page (Tab). To this end, I created a separate tab for many street names, then I cut data from Smith Street rows (on the All_Streets tab and Paste > Link onto a SmithStreet tab, repeating this for various streets on various StreetName tabs.

When I deliver this finished Workbook to the City, they will periodically need to Edit data in the file. Not being power users, it will be easiest for them to do their Edits on the separate StreetName tabs, rather that deal with the full table/spreadsheet.

Here's my challenge, or my question:
Is there a way to configure the workbook and tabs so that updates can be made either in the full table (All_Streets tab) or on the StreetName tabs *where edits in either location will cause an update in the other?* Ideally I'd like these edits & updates to work both directions.

Please share any ideas you have on how to set up bi-directional editing and updates.

Thanks much, in advance...
Dave