I have a google sheet with over 20 tabs.
The main tab which is a list of items (proffessions) and it is displayed in the main screen - the only tab that is displayed.
I wish that every time i enter the main page looking for a specific proffesion, i’d be able to click on it, see the component List relation.
But for every proffesion - every listing, the relation is different.
So for the Accountent i link it to the accountent tab
And for the Architect i can link it to the architect tab
What happens now is when i change one- it changes all the links.
Can it be done?