Temporary / Default Views aren't working as I expected

I have an online excel that has our customer terms in it, we want our customer service team of 10 to be able to use this excel and filter by the customer they're speaking with on the phone.

My understanding was that if you created a new view, you could filter and select without impacting other users, but that doesn't seem to be the case. The temporary/new/saved views are all controlling each other.

Inside is a dropdown, and once selected, all the other cells change.

Default view = select a customer = changes all other views to that customer

Temporary view = select a customer = changes all other views to that customer

Saved view = select a customer = changes all other views to that customer