If you want to pick-up certain field from two tables, you might be
better off jumping into Access, importing the two tables separately,
creating a query that links the application name and then selects
field from both tables based  on your desired final table.

You could then run the query and copy the data  back into Excel (if it
is a one time thing, otherwise you may want to link Excel). I know
this is at a high level - if you are not familiar with Access and
need more detail, let me know.