I'm working on a spreadsheet where I want to have a main data entry worksheet that can link to individual worksheets for each member of my team. I've renamed each worksheet to the name's of each person on my team. On my data entry page, I'd like to have a drop down menu with each member of my team's name in there. After picking a name, I have the datafields set to drop down menu's where the inputer chooses a Y, or an N. After inputing that data, plus filling in a date cell, I'd like to simply hit a button and have that info transfer to that particular individuals worksheet, who's name I selected from the drop down menu, and autopopulate the proper fields.

I have zero VBA experience. Any help would be appreciated.