Just a thought, not even halfway to a solution, do you have to have the data for the different shifts on separate worksheets?
I would have thought it easier to have a single sheet for your baseline data, with an extra column to indicate which shift the person was engaged in. You can always use other methods to show/ print out reports for the separate shifts, if that information is required separately.