Hello,

I have a workbook for collecting body composition information. Every month a group of 10-50 people with have their body composition analyzed and I would like to compile the results on to worksheets based on each name. When I run a new test some of the name could change and each person will have a differing number of previous test. I can no figure out how to set up a macro to search the the worksheet names and match to the value off the master sheet, then past the information from the master into the first open row. I would also like to figure out an msgbox/error box for if a name does not match a worksheet to either change the name or add a new sheet. I have attached the workbook with a few of my bad attempts at a macro. I am also open to suggestions if there is any easier way to organize this process. Any help would be greatly appreciated.

Thanks

Body Comp Template.xlsm