no sheet for each day yet as I wanted to see if this could be done before doing so. The sheets are named 1,2,3-30(31)Unfortunately, I cannot download files from my current location, so I cannot see your file.
I am still a little unclear where this data is being copied to.
Is there a sheet for each day in the file already, or does it need to be created?
How exactly are these sheets named? Is it with the full date?
I think automation is always preferrable to manual, in that:would it even be worth it, all I want to do is minimize the human factor in the data input but seems that in order to do it would be too arduous a process and just having 1 person copy and pasting after sorting would be better.