One Excel File To One File With Many Tabs

I use Excel 2007 and would like to simplify my life. Would like to have one Workbook (base) that does all the programming. I'd like to enter a list of names into a base worksheet within the base Workbook. Next, depress a button on the base workbook that asks me to open another Excel file. Once this file is opened, select a tab and make as many copies as there are names listed in my base Workbook list. The tab names would come from the list I placed in the base workbook. Once all tabs are copied and named would like to save it automatically (do a save as) after all is finished. It sounds simple but with a button, opening file, creating tabs from a list and asking to save the file is a lot of stuff for a novice. Your help much appreciated.

Tony