Split data from multiple sheets to tables for summary sheet based on dropdowns

Report
Posts
10
Registration date
Wednesday March 3, 2021
Status
Member
Last seen
June 7, 2021
-
Hello,
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
note : my real data are about 2300 rows and they're increasable
this is my file
https://www.dropbox.com/scl/fi/czbxi7puutj5yk1ehdk03/SS.xlsm?dl=0&rlkey=yjskil5qil4gwwmw716czs137


System Configuration: Windows / Chrome 91.0.4472.77