I have a master worksheet of names and in column D I have a dropdown of 12
names. These 12 names have a corresponding worksheet in this same workbook.
I would like to choose a name from the dropdown and then have the data from
column B & C copied to the corresponding worksheet to column B & C. So
something to the effect of IF D3=Name1, then copy B3 & C3 to Name1 worksheet.
Not sure how to handle this, if it's an IF statement, a LOOKUP or a MACRO.

The 2nd part of the equation is: While copying can Excel look at the
worksheet being copied to and paste the data in the next available row? So
if B3 & C3 have data already in them, paste to B4 and C4.

Thanks for any help anyone can offer.