Hello!

I have a lot of personnel data in one spreadsheet currently. I want to break this information out across a few tabs, however I'd like to keep all the employee names and a bit of extra corresponding information on each tab.

Is there a way to keep everything on one tab and then break out the information across additional tabs so that different parts of the data can be viewed on different tabs? Basically similar to hiding columns so that only some information is viewable on each tab, but when you update John Doe's name on the first tab, it'll change on the second tab because it's literally the same data, just a different view.

Does that make sense? I can't attach an example because I don't know how to do it (which is why I'm posting!).