In the samples, the Worksheet is newly created each day with the file name following the pattern of 'Worksheet mm.dd.yyy' and this is where the data for the day is gathered.

Then there are currently 22 of the individual sheets that the data needs to be distributed into. How can I get the individual sheets to update automatically?