In script window you can add every single file by clicking on tablefile button and select the excel file.
This will autogenerate a script for you.
Now to link two tables you need to give same name to the fields through which you have to link those two tables. Just like below.
p, q, r as c
Here you are linking Table1 and Table 2 by field name c and r respectively. Thus we renamed one field r to c. So that both the table links to each other.