Sorting one table will sort another table

[Dian11]

NAME	SURNAME		NAME	HOURS
name1	sur1		name1	1
name2	sur2		name2	2
name3	sur3		name3	3

NAME + SURNAME = Tabel 1
NAME + HOURS = Table 2

Is it possible to connect Table 2's NAME column to Table 1's NAME column, so that if I sort Table 1 NAMES, Table 2 will also get sorted?

I can connect the NAMES but when I sort Table 1, the HOURS of Table 2 does not sort with it.

[#2]

@Dian11 

It doesn't sort the second table because you have a blank column in between the tables. To achieve this, insert some dummy text in C1 say "Dummy Column" then select C1 and press Ctrl+1 to open the Format Cells window, then under Number Tab go to Custom and in the textbox under the Type, type ;;; (three semicolons) so that the dummy text in C1 will be displayed. And now the second table will also get sorted along with the first table.

[#3]

The two tables have to be separate. I should be able to put table 1 on a sheet, and table 2 on different sheet. Then when I sort the NAMES in table 1, table 2 on a different sheet will also sort.