How to move specific cells in a row to a specific sheet based on cell value.

So, I have a workbook with every letter of the alphabet as a sheet. My goal is have 1 sheet where all the data is typed into and (hopefully via a module or macro) have excel send said data to the proper sheets. The way it should decide what goes where is by first letter of name.
Also, i want to add another sheet that cherry picks specific data to move. For example, sheet 'A' receives the full row of data regarding people who's last name starts with A, but sheet 'Report' receives only the person's name, date of birth, and phone number.
Any help or guidance would be greatly appreciated. Thank you.