Hi mr.chris.strange

Welcome to the Forum!!!

I think you may be well served by using a User Input Form to add the Samples to the Data Forms.

Just noodling...questions come to mind...there will be others...

Will your Sheet Names actually be "like" George's - Cassville and George's - Springdale? Will there be more than just these two?

Do you really want the Header Rows repeated between each Days Samples?

Will the User be entering the Samples in Batches and KNOW when she/he is finished for the day such that the Averages can be calculated for that Batch?