VBA Macro to find duplicates on different columns in different sheets and countif value

[Nisshaheen]

Good day
I have workbook with multi sheets named as today date
in each sheet column x route nam the count of this route in column y I'm creating macro to copy all route with unique value and paste the result in sheet (main of month) column Aa.
I want to compare column x in all sheets with column aa in result sheet and count each route the number of each route will be in column ab
I'm try but all macro I tested not work with my planning
Any help many thanks