One master sheet to have same data on multiple sheets?

[685villa]

What I want to do:

I have a workbook with a master sheet of names (40ish people) and I want these names on 30ish other sheets. The master sheet names will occasionally change as company staffing changes.
for the master sheet, I would want just 3 columns of info pulled onto other sheets. However, each sheet will have a rather large set of data in a lot of columns.
Then would I create a master table (on master sheet) with a lot of empty columns and have a VLOOKUP only on the first 3 columns of the master table then have each sheet's table only referencing/looking up the respective first 3 columns from the master sheet?


I still would like to have the ability of filtering each table (via the first 3 columns) on each subsequent table on the other sheets.
I have a lot of example formulas, but they're not compatible with the changing info of the first 3 columns on a master sheet. I am wanting to aleviate the need to edit the first 3 columns of info on each sheet individually, or copy/paste/transpose on the other sheets from the master sheet.


I am looking at creating a single one-stop-shop for all info pertaining to my company since I have A LOT of info to track for each person (ergo the multiple other sheets).
Or do I just copy 3 columns of info and paste the link onto the first 3 columns' tables in the other sheets?


Thanks a lot!
-V

 

[Fluff]

Duplicate to: How do I get one master sheet of names that can be regularly edited and have those names on multiple other sheets?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.