How are you intending to merge  the data? I think I would just perform a
copy/paste command to append to the end of your list.

I am not sure I understand the complexity of your question. Do you want
to maintain two sets of labels?

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.