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

I really do appreciate your time in this.... So I've attached the results after I've downloaded your file and run it. I'm guessing it is something to do with the date format, not sure, but when I run your macro, it creates 15 sheets (ending with template (16)), and none of the sheets have more than 2 lines of data.
Could you write the macro where it decides whether it goes on the same sheet as another by the number in column A? I can add that column to my data and basically assign a sheet number based on the name & date. For some reason, on your end, it works, but on my end, it puts each line on it's own sheet. . Thoughts for my suggestion or another to work around that? Any suggestion/solution is so appreciated! Thank you again for all your
efforts. Thanks again!