What would be the best way to add data from one excel to another based on an email column.

[rmartori]

So I need to combing 5 excel files into one excel. 

Afterwards I have a 6th excel with two columns column A is just emails and column B is the employees rank within the company(associate, manager, etc)

In the 5 excel files I am merging together email is in column F and Title where I want to put the matching rank, is in Column E

What would be the best way to do this?

[Emil_Kos]

Hi @rmartori,

I the 5 excel files have the same structure you can use union tool.

To add information using something similar to vlookup function you need to use join tool.