There's a way to do this but with more cells?
I have a Resume sheet thats shows the total of several worksheets.
In the resume sheet I have a cell with the list of branches of the company.
In every worksheet i have a cell with the list of branches, so with a =filter() I can see the details of the branch selected in the resume worksheet.
So I want that anytime I change the branch in any worksheet, all the other cells change it's value to the branch I select y any worksheet
I'm not sur if I'm being clear enough