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.