Collating Data

[Skybluekid]

Hi All,

I have been asked by my sales director to collate information from his sales staff. Currently, they use a single shared workbook, they have their own sheet, which has a table on it. I have been asked to gather information which relates to activities of the sales people.

Getting the info for the sales is easy, but I have to cross reference a specific activity between all the salesperson. I am little a bit stuck on how to do it.

I have thought of using Power Query or Power pivot. Any help in an easy solution?

Thanks in Advance.