Summarise multiple excel worksheets into one sheet

[bob112233]

Hi,

I have multiple excel sheets names (raw data 1, raw data 2 etc) and each sheet as the following headers (ID, Surname, First Name, Job, Q1,Q2,Q3,Q4)

Q1,2,3,4 = Quarterly Earning

I want to combine all my raw data sheets (1,2 ... n) such that I can easily identify those individuals with the lowest and highest Q1,Q2,Q3,Q4.

I currently don't have any desired results because I can't figure out how to display my final results. All I know that I need to be able to filter by first name, surname to identify those individuals with the lowest or highest Q1,2,3 and 4.

Any help or guidance is greatly appreciated.

PS- I will try to come up with some desired results.

Thanks