How can I get 1 table's info mirrored/queried (?) onto other tables? Other tables' info columns need correlation with the first 4 columns.

[Yertion]

Table 1 (Master Table) has only 4 columns of basic admin info.

Other tables have more than 4 columns (rows wouldn't change) but I would want the "Master Table's" 4 columns on each other table while being able to update names/departments only on the "Master Sheet."

Maybe I just really suck at explaining what I'm looking for.....? I am a federal employee now overseeing projects and the like, and having a central tracking mechanism would be very beneficial.

Other tables that are larger than a queried (?) table can associate/correlate the additional column's info from the Master Table's 4 columns?

Thank you so much for your help!


Here is Sheet 1, or rather the "Master Table":

base template.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3
4		DEPARTMENT	PROGRAM	OFFICE	NAME
5		department1	program1	office1	last, first name1
6		department2	program2	office2	last, first name2
7		department3	program3	office3	last, first name3		1) This is the "master sheet" that I would like to use to update information on people, and so on.
8		department4	program4	office4	last, first name4
9		department5	program5	office5	last, first name5
10		department6	program6	office6	last, first name6
11		department7	program7	office7	last, first name7		2) How then can the info on this sheet be on subsequent sheets/tables while staying updated with the info on this table?
12		department8	program8	office8	last, first name8
13		department9	program9	office9	last, first name9
14		department10	program10	office10	last, first name10
15		department11	program11	office11	last, first name11		3) Lastly, how can this info stay updated on the other tables that each have far more columns than this? I just want these 4 columns and 50 rows on multiple other tables that each will have different information, usually text and dates. Each of the other tables' rows/columns would need to be reflective of this table's info (names mainly) and their associated info.
16		department12	program12	office12	last, first name12
17		department13	program13	office13	last, first name13
18		department14	program14	office14	last, first name14
19		department15	program15	office15	last, first name15
20		department16	program16	office16	last, first name16
21		department17	program17	office17	last, first name17
22		department18	program18	office18	last, first name18
23		department19	program19	office19	last, first name19
24		department20	program20	office20	last, first name20
25		department21	program21	office21	last, first name21
26		department22	program22	office22	last, first name22
27		department23	program23	office23	last, first name23
28		department24	program24	office24	last, first name24
29		department25	program25	office25	last, first name25		Perhaps I just suck at explaining what I am looking for or don't know how to detail this? Regardless, thank you so much for the help!
30		department26	program26	office26	last, first name26
31		department27	program27	office27	last, first name27
32		department28	program28	office28	last, first name28
33		department29	program29	office29	last, first name29
34		department30	program30	office30	last, first name30
35		department31	program31	office31	last, first name31
36		department32	program32	office32	last, first name32
37		department33	program33	office33	last, first name33
38		department34	program34	office34	last, first name34
39		department35	program35	office35	last, first name35
40		department36	program36	office36	last, first name36
41		department37	program37	office37	last, first name37
42		department38	program38	office38	last, first name38
43		department39	program39	office39	last, first name39
44		department40	program40	office40	last, first name40
45		department41	program41	office41	last, first name41
46		department42	program42	office42	last, first name42
47		department43	program43	office43	last, first name43
48		department44	program44	office44	last, first name44
49		department45	program45	office45	last, first name45
50		department46	program46	office46	last, first name46
51		department47	program47	office47	last, first name47
52		department48	program48	office48	last, first name48
53		department49	program49	office49	last, first name49
54		department50	program50	office50	last, first name50
55		department51	program51	office51	last, first name51
56
Sheet Master

Here is another table that I am wanting only the first 4 columns from the "Master Table" auto populated onto this table, and even more tables beyond this one.

base template.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N
1						These rows and columns will each have unique information associated with a name.
2
3
4		DEPARTMENT	PROGRAM	OFFICE	NAME	CONTRACTOR	PROJECT LEAD	CONTRACT DATE	CONTRACT END DATE	RENEWAL?	MANUFACTURERS
5		department1	program1	office1	last, first name1
6		department2	program2	office2	last, first name2
7		department3	program3	office3	last, first name3
8		department4	program4	office4	last, first name4
9		department5	program5	office5	last, first name5
10		department6	program6	office6	last, first name6
11		department7	program7	office7	last, first name7
12		department8	program8	office8	last, first name8
13		department9	program9	office9	last, first name9
14		department10	program10	office10	last, first name10
15		department11	program11	office11	last, first name11
16		department12	program12	office12	last, first name12
17		department13	program13	office13	last, first name13
18		department14	program14	office14	last, first name14
19		department15	program15	office15	last, first name15
20		department16	program16	office16	last, first name16
21		department17	program17	office17	last, first name17
22		department18	program18	office18	last, first name18
23		department19	program19	office19	last, first name19
24		department20	program20	office20	last, first name20
25		department21	program21	office21	last, first name21
26		department22	program22	office22	last, first name22
27		department23	program23	office23	last, first name23
28		department24	program24	office24	last, first name24
29		department25	program25	office25	last, first name25
30		department26	program26	office26	last, first name26
31		department27	program27	office27	last, first name27
32		department28	program28	office28	last, first name28
33		department29	program29	office29	last, first name29
34		department30	program30	office30	last, first name30
35		department31	program31	office31	last, first name31
36		department32	program32	office32	last, first name32
37		department33	program33	office33	last, first name33
38		department34	program34	office34	last, first name34
39		department35	program35	office35	last, first name35
40		department36	program36	office36	last, first name36
41		department37	program37	office37	last, first name37
42		department38	program38	office38	last, first name38
43		department39	program39	office39	last, first name39
44		department40	program40	office40	last, first name40
45		department41	program41	office41	last, first name41
46		department42	program42	office42	last, first name42
47		department43	program43	office43	last, first name43
48		department44	program44	office44	last, first name44
49		department45	program45	office45	last, first name45
50		department46	program46	office46	last, first name46
51		department47	program47	office47	last, first name47
52		department48	program48	office48	last, first name48
53		department49	program49	office49	last, first name49
54		department50	program50	office50	last, first name50
55		department51	program51	office51	last, first name51
56
Sheet Dept

This is another sheet that, again, I am wanting only the "Master Table's" info on the first 4 columns of this table:

base template.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N	O
4	DEPARTMENT	PROGRAM	OFFICE	NAME	WORKING GROUP	PROJECT MANAGER	ARRIVED AT COMPANY	DEPARTMENT ARRIVAL	ONLINE TRAINING1	ONLINE TRAINING2	TELEWORK	READ IN?	NDA?
5	department1	program1	office1	last, first name1
6	department2	program2	office2	last, first name2
7	department3	program3	office3	last, first name3
8	department4	program4	office4	last, first name4
9	department5	program5	office5	last, first name5
10	department6	program6	office6	last, first name6
11	department7	program7	office7	last, first name7
12	department8	program8	office8	last, first name8
13	department9	program9	office9	last, first name9
14	department10	program10	office10	last, first name10
15	department11	program11	office11	last, first name11
16	department12	program12	office12	last, first name12
17	department13	program13	office13	last, first name13
18	department14	program14	office14	last, first name14
19	department15	program15	office15	last, first name15
20	department16	program16	office16	last, first name16
21	department17	program17	office17	last, first name17
22	department18	program18	office18	last, first name18
23	department19	program19	office19	last, first name19
24	department20	program20	office20	last, first name20
25	department21	program21	office21	last, first name21
26	department22	program22	office22	last, first name22
27	department23	program23	office23	last, first name23
28	department24	program24	office24	last, first name24
29	department25	program25	office25	last, first name25
30	department26	program26	office26	last, first name26
31	department27	program27	office27	last, first name27
32	department28	program28	office28	last, first name28
33	department29	program29	office29	last, first name29
34	department30	program30	office30	last, first name30
35	department31	program31	office31	last, first name31
36	department32	program32	office32	last, first name32
37	department33	program33	office33	last, first name33
38	department34	program34	office34	last, first name34
39	department35	program35	office35	last, first name35
40	department36	program36	office36	last, first name36
41	department37	program37	office37	last, first name37
42	department38	program38	office38	last, first name38
43	department39	program39	office39	last, first name39
44	department40	program40	office40	last, first name40
45	department41	program41	office41	last, first name41
46	department42	program42	office42	last, first name42
47	department43	program43	office43	last, first name43
48	department44	program44	office44	last, first name44
49	department45	program45	office45	last, first name45
50	department46	program46	office46	last, first name46
51	department47	program47	office47	last, first name47
52	department48	program48	office48	last, first name48
53	department49	program49	office49	last, first name49
54	department50	program50	office50	last, first name50
55	department51	program51	office51	last, first name51
Sheet Program