VBA for a newbie help on consolidating sheets on 1 master sheet

hi guys,

thanks for help firstly

so I have a work sheet- this sheet has a few tabs on it- one being master and the others names of people, what I would like is for every time a person enters data into there name tab for it to automatically update or create a copy on the master sheet... what I don't want it to do is copy the first row which is the header..

I'e attached an example, I would appreciate where I need to edit to apply it to a file that is already in use.

thanks,

gaby