How could I extract text info from a single table of 3 columns (names, department, and pay grade) onto other tables with many more columns?

[685villa]

Department​	Pay Grade​	Name (last, first)​
HR​	GS12​	Name, Sample
Ops​	GS13​	Sample, Name
Ops​	GS11​	last, first
	​

Example of one of the many other tables:

Department​	Pay Grade​	Name​	Arrived​	Leaving​	Evaluation Due​	Cell Phone #​	Upcoming Work Trip​	Online Training 1​	Online Training 2
info from master	info from master	info from master

On the main table of 3 columns (names, department, pay grade) I would like to have those 3 columns on 20+ other sheets' tables. Each table will have many more columns of different type of info.

How could I associate those 3 (master?) columns and rows with all of the additional columns on the other tables?

As well, as people move in and out of the department, the names and such regularly change, which is why I would like this to be a 'master' table so that I don't have to copy/paste new names regularly onto the other tables.

Example of this 'master' table:




With the new columns of info, how can that be associated with the first 3 columns, assuming that info comes from one table on another sheet? If this is via power query, what type of merge and Join Kind would this be?
Thanks for the help!