I was so successful last time on this forum I've decided to give it another shot!

This might be a doozie (at least it is in my inexperience VBA brain). But anyhow, here's what I'm trying to do...

I want to create a button that will export 7 sheets (that is "Day1", "Day2", "Day3"... "Day7") to a new workbook. I then want to rename this new workbook to the contents of cell D1 on a sheet called "Home".

D1 is actually a dropdown list where you select a name. Depending on this selection, all information in sheets "Day1" - "Day7" changes to match the information to that specific person selected. Therefore, what I am essentially trying to do is select a persons name and then export their information as it is currently shown on "Day1" - "Day7" to a new workbook and name the workbook after the person selected. This way I will be able to print/send someones specific information without sending my whole master file.

Thanks in advance for your help.

Ian.