Excel Data Query (Fast simple)

Excel sheets Droped in a folder . Main execel opens and load all the excels in this folder (I have done that using data query folder). The excel sheets are have all similar data and same headers and everything . so when all these excel combined they will be 1 excel sheet. 1- Excel have different id with in every row but there (unique number) that is repeated all over the rows i want to filter all data for every unique id . After that calculate profit for each id. 2-Show id most profitable and a formula that i ll give u to show best performance id . and give me the ids of the best ex: alpha,beta,s2,d3,ff4 so i can copy paste the result to another software It shouldnt take long but im bad in explaining . i ll explain to u privatly it will be easy if you know excel good