transpose data through multiple sheets calculate the values based on three datavalidation

hi
I have data about five sheets sometimes contain the same data are duplicated then should merge and summing the values as show in sheet summary based on three data validation when select the item from three data validations in cells C2,D2,E2 should shows data as what I design in sheet summary with same borders and formatting I would show each three tables next to each of them and I put the formula in BALANCE but I would show as value and if the data validation are empty brings all of the tables and every time select the items should copy to the bottom but if it's already existed it shouldn't copy to the bottom again and if I change the data for each sheet of them then should update in sheet SUMMARY .
last thing if there is way to link items with data validations across multiple sheets without use helpers columns just link directly based on the first and the second sheet without any duplicated.
I put the result in sheet SUMMARY based on selection data validations