Hi,

I need to create 5 new workbooks based on the one master workbook I have. These will each have the same 5 names every time, but will be updated with the date every time I run them. Ex: Workbook1_04-14-15, Workbook2_04-14-15, etc. and these will have tomorrow's date when I run them tomorrow.

Steps:
1. Open master workbook
2. Add 5 new workbooks, save as Workbook1_04-14-15, etc.
3. Copy data from Workbook1 tab in Master Workbook and paste into Workbook1_04-14-15 and do the same with the other four workbooks
4. Save workbooks
5. email workbooks to particular employees (will be the same every week, Workbook1 always goes to employee 1, workbook2 always goes to employee2 etc.)

Not exactly an expert when it comes to VBA programming, so I'm trying to learn. Guidance would be better than answers, but I'll take anything!
My thought was to start by creating 5 new workbooks with workbooks.add. I could write it five times but I thought it might make more sense to enter it as a variable? Would I use Do Until variable name = 5 new workbooks? Not sure how to write that.

Thanks!