Different Views of Same Data on Different Tabs

[OZover]

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!).

[ben_hensel]

I'd just create the new worksheet, call it, sheet2 for this example
and then point at the data on the original sheet, call it sheet1

Like this:
In sheet2:
A1 = Sheet1!A1

So that will display whatever's in sheet1, A1, in sheet2, A1. then you could pull down and out to display.

Or you can copy => paste special => link for a selected array to do the same thing for the selection.

Anyway that's just linking one cell to another, across worksheets.

[OZover]

Thanks, Ben!

That works, but what happens if I delete a row of data (ie an employee due to attrition or something similar) from the original spreadsheet? That will return an error for the employee's name but will keep all the other data on the secondary spreadsheet (the one that will have cells pointing to the original spreadsheet's cells, ie the employee's name). I was just wondering if there was a cleaner way to go about this.

I need to keep it simple for people who may take over if I ever leave this position. Any other ideas?