Search for & open, or copy & open, workbooks, maybe contain multiple workbooks in one?

[Stupidio]

Hello,
Here's what I want to do: For Q&A, I have a number of employees, each of which have a total of 20 instances of work checked per year, all with identical reports, where say 10 or so questions are answered with 1 of 3 drop down menu answers. So, I've created individual workbooks for each employee, with the 20 identical questionnaires as separate sheets, and a sheet at the end giving totals for each answer.
I haven't figured out how to have several employees each with 20 sheets in a single workbook, so I figure I can have an individual workbook for each employee, with the figures I'm looking to compile being identical in placement, and then I can figure out how to create a "master" workbook to compile the totals from each individual workbook to amass total results of the team.
Being able to have each employee detailed as above in a single workbook would be nice, and I'll accept how to do it if it's possible, but what I'm really looking for is this:
On the "master" workbook, in a single column labeled "Name", I would like to type in a person's name (if not there already), and have Excel (2010 standard, with Windows 7) look in a particular Windows directory for a file containing that particular name (eg: Jones, Excel would search for Jonesfile.xlxs) and said file exists, open it. However, if Jonesfile.xlxs does NOT exist, then I would like Excel to copy "Masterfile.xlxs" as "Jonesfile.xlxs" to that directory and open it. If "Jones" already exists in the "Name" column, then clicking on it should open the "Jonesfile.xlxs" workbook.
I appreciate any help offered, within the Forum rules, of course.
Thank you!

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)