Generating multiple sheets within a workbook all titled with a ca.

I have a list of names that I need to make a individual sheet for. Can I
create the sheets without having to individually name them? Also, I need
these sheets to all be formatted the same way, each with VLOOKUP functions in
a cell corresponding to the title of the sheet, which refers to another
workbook.

Nevermind. I found the answer on this website
http://www.mvps.org/dmcritchie/excel/sheets.htm

"Matt" wrote:

> I have a list of names that I need to make a individual sheet for. Can I
> create the sheets without having to individually name them? Also, I need
> these sheets to all be formatted the same way, each with VLOOKUP functions in
> a cell corresponding to the title of the sheet, which refers to another
> workbook.