create a new sheets & copy data from sheet to multiples and sum based on month

hello
i have data about 10000 rows but i attach a simple data to understand me i would when choose from dropdown the month it creates sheet's name the month like jan and bring all of data relating this month and insert total in lastrow to sum data with grey color so and if i repeat again data already existed then ignore them just a new data i apply that as example in sheet"jan" after choose from dropdown in h1 to understand what i want

hi, sintek sheet1 is new data just been added to the bottom

it gives me run time error 13 in this line

HTML Code: 

this is mystery sintek i uploaded file in post #6 it directly shows me the same error there is something wrong but i no know

i did it nothing happens

does it work for you ?

unfortunately still error continues

sorry sintek if i waste your time after many tries for your code i have found the problem my office is Arabic language if dropdown is not match with the language of office then cause the problem i converted to Arabic language the code works very well as your picture above but i have last thing to amend the code in sheet1 if the dropdown is empty when run the macro sum all of data in sheet1

hi, sintek could you do the same thing about the border and merge cell "total" the lastrow as in months

you have achieved great work i would thank you for your assistance and time many thanks