In the first worksheet of my workbook I have a list of part numbers listed in
a column, say approximately 20 part numbers. I would like to have one
worksheet for each part number, with cell A1 containing the part number for
that worksheet.

So if my list was:

pn1
pn37
pn469
pn2034

then cell A1 of the first worksheet in the series would ="pn1", cell a1 in
the second worksheet of the series would ="pn37"

Is there an easy way to populate these worksheets from the list?

Thanks,

Rob Samples