Just thinking out loud here...

You could manually open another workbook that has a list of your individuals, and contains macros to copy and paste as required for the individuals.

Using the file picker dialog
Application.FileDialog(msoFileDialogFilePicker)
you could set the "Worksheet mm.dd.yyyy" file to be used.

Then cycle through the list of individuals one at a time calling the appropriate macro to copy and paste the required data for that particular individual.

The number of macros required for the individuals was kinda what was eluded to in post 5

PS: row 5 of your sample worksheet has only 21 individuals