Need Help With Matching Function

Hey All,

I need some help with excel vba/fuctions.

I have to add a list in a different tab daily, and I need to find a MACTH with a certain PERSON in a tab and MATCH his numbers on a daily basis. How do i go about doing that in VBA? The numbers will be refreshed daily and there are over 400 people on the list, and manually doing this will be a pain in the a**. Can someone please help. Thank you in advance.

Example:
Find John Doe on both tabs, and on main tab, put "John Doe 2 tickets Monday"

A2: John Doe
B1: Monday
B2: 2 Tickets

I already have coded up to the point where it will ADD John Doe on the main tab, but, dont know how to match it on a daily basis.