Need macro to copy data from 1 sheet to multiple sheets based on certain criteria

Like professor Higgins I feel I can now say "My God I got it!"

Well the quote is not really like that but it was the best I could think of. File is also tested in an US environment and runs fine. The crux of the matter was the formula I added to the
macro i.e. =TEXT(cell,"mm-dd-yyyy")

This will give you date in the format mm-dd-yyyy, and if you wish for another format just change the line

Range("C2").Formula = "=TEXT(G2, ""mm-dd-yyyy"")"

to the format you wish for as long as there are no forbidden characters in it.

So just click on the macro "ArrData" and do a rerun to test and you don't need to delete all the result sheets, the macro will do that.

Alf