Link and Sort Across Excel Sheets

[dnelley]

I have an excel file with multiple tabs.
In the initial tab are data entry items that I want to be consistent throughout the other tabs
I am able to link these data
However, when I sort the data in one sheet it does not the corresponding data in the rows of the other sheets do not sort along
How can this be done
Below I've tried to provide a visual of what I am talking about

1 - LINK AND DATA ENTRY (TWO TABS SHOWN BELOW)

TAB 1
A	B	C	D	E	F	G	H
NAME ENTERED ONLY IN TAB 1	ID NUMBER ENTERED ONLY IN TAB 1	DATE ENTERED ONLY IN TAB 1	STATUS ENTERED ONLY IN TAB 1	STAFF ENTERED ONLY IN TAB 1	DATA ENTRY 1 ENTERED ONLY IN TAB 1	DATA ENTRY 2 ENTERED ONLY IN TAB 1	DATA ENTRY 3 ENTERED ONLY IN TAB 1
Mathew Bellamy	0634	1/15/16	active	PJ	Lexington	1	master
Mark Twain	1124	2/3/16	inactive	JB	Broadway	3	bachelor
Luke Sky	7110	5/8/17	active	MC	Junction	1	diploma
John Cena	0316	4/1/18	active	PJ	Square	1	bachelor

<tbody>
</tbody>

TAB 2
A	B	C	D	E	F	G	H
NAME LINKED FROM TAB1	ID LINKED FROM TAB1	DATE LINKED FROM TAB1	STATUS LINKED FROM TAB1	STAFF LINKED FROM TAB1	DATA ENTRY 4 ENTERED ONLY IN TAB 2	DATA ENTRY 5 ENTERED ONLY IN TAB 2	DATA ENTRY 6 ENTERED ONLY IN TAB 2
Mathew Bellamy	0634	1/15/16	active	PJ	Good	Excellent	Bad
Mark Twain	1124	2/3/16	inactive	JB	Excellent	Very Good	Not Bad
Luke Sky	7110	5/8/17	active	MC	Very Bad	Not Bad	Not Bad
John Cena	0316	4/1/18	active	PJ	Good	Good	Good

<tbody>
</tbody>

2 - SORT TAB 1 BY DATE (WHAT HAPPENS)

TAB 1
A	B	C	D	E	F	G	H
NAME ENTERED ONLY IN TAB 1	ID NUMBER ENTERED ONLY IN TAB 1	DATE ENTERED ONLY IN TAB 1	STATUS ENTERED ONLY IN TAB 1	STAFF ENTERED ONLY IN TAB 1	DATA ENTRY 1 ENTERED ONLY IN TAB 1	DATA ENTRY 2 ENTERED ONLY IN TAB 1	DATA ENTRY 3 ENTERED ONLY IN TAB 1
John Cena	0316	4/1/18	active	PJ	Square	1	bachelor
Luke Sky	7110	5/8/17	active	MC	Junction	1	diploma
Mark Twain	1124	2/3/16	inactive	JB	Broadway	3	bachelor
Matthew Bellamy	0634	1/15/16	active	PJ	Lexington	1	master

<tbody>
</tbody>

TAB 2
A	B	C	D	E	F	G	H
NAME LINKED FROM TAB1	ID LINKED FROM TAB1	DATE LINKED FROM TAB1	STATUS LINKED FROM TAB1	STAFF LINKED FROM TAB1	DATA ENTRY 4 ENTERED ONLY IN TAB 2	DATA ENTRY 5 ENTERED ONLY IN TAB 2	DATA ENTRY 6 ENTERED ONLY IN TAB 2
John Cena	0316	4/1/18	active	PJ	Good	Excellent	Bad
Luke Sky	7110	5/8/17	active	MC	Excellent	Very Good	Not Bad
Mark Twain	1124	2/3/16	inactive	JB	Very Bad	Not Bad	Not Bad
Matthew Bellamy	0634	1/15/16	active	PJ	Good	Good	Good

<tbody>
</tbody>

issue: cells not linked to the previous tab (columns F-H) did not sort along with the linked cells (columns A-E)​

3 - SORT TAB 1 BY DATE (WHAT I WANT TO HAPPEN)

TAB 1
A	B	C	D	E	F	G	H
NAME ENTERED ONLY IN TAB 1	ID NUMBER ENTERED ONLY IN TAB 1	DATE ENTERED ONLY IN TAB 1	STATUS ENTERED ONLY IN TAB 1	STAFF ENTERED ONLY IN TAB 1	DATA ENTRY 1 ENTERED ONLY IN TAB 1	DATA ENTRY 2 ENTERED ONLY IN TAB 1	DATA ENTRY 3 ENTERED ONLY IN TAB 1
John Cena	0316	4/1/18	active	PJ	Square	1	bachelor
Luke Sky	7110	5/8/17	active	MC	Junction	1	diploma
Mark Twain	1124	2/3/16	inactive	JB	Broadway	3	bachelor
Matthew Bellamy	0634	1/15/16	active	PJ	Lexington	1	master

<tbody>
</tbody>

​

TAB 2
A	B	C	D	E	F	G	H
NAME LINKED FROM TAB1	ID LINKED FROM TAB1	DATE LINKED FROM TAB1	STATUS LINKED FROM TAB1	STAFF LINKED FROM TAB1	DATA ENTRY 4 ENTERED ONLY IN TAB 2	DATA ENTRY 5 ENTERED ONLY IN TAB 2	DATA ENTRY 6 ENTERED ONLY IN TAB 2
John Cena	0316	4/1/18	active	PJ	Good	Good	Good
Luke Sky	7110	5/8/17	active	MC	Very Bad	Not Bad	Not Bad
Mark Twain	1124	2/3/16	inactive	JB	Excellent	Very Good	Not Bad
Matthew Bellamy	0634	1/15/16	active	PJ	Good	Excellent	Bad

<tbody>
</tbody>

my ideal: if cells are sorted in either tab the corresponding data entered in the rows of the other tabs will also sort​