Ok new to programming VBA first off.

My problem is I have two sheets they both contain a long series of names, some of the names between the two sheets are the same.

For each name there are four columns containing data that I filled out.

Im wanting names that match between the two sheets to have that data in the four columns auto populate

Names are in Column A
Data in columns E through H

thanks in advance for the help.