Link two tables in the same sheet of multiple excel files

[#1]

Hi Community,

I have a whole crop of excel files with the same format. I would like to load data from all of these files into Qlikview with a FROM *.xls. However, on a single sheet in the excel document there is more than one table that I need. For simplicity, I have illustrated two tables in one sheet, and how I would like to load them into Qlikview, below:

I need to take a separate table, that Timing table in the upper right of the picture, and link it to the Key Code with Qlikview so that my data is dynamic. On all of my excel sheets, there is a different Key Code. I would like each Key Code to provide a link between that left table and that right table for each Excel sheet. How do I add that Key Code onto the timing table in Qlikview to achieve what I illustrated in Table 2? Keep in mind, I am hoping for a solution via code that will apply to all of my excel files that look like this, so I would hope to do no manual editing of excel files. I hope that all makes sense.

Any ideas? Thanks.