automatic file generation and fill in from list

I did a search, but I am not even sure what to call this.

I have a workbook with a list of 250 items, and need a new workbook and filename for each row in the list.

In each row of the list there is two cells I need to copy into the new workbook.

What I would like to do is generate a new workbook with the layout/format add the two cells, and then save the new workbook using one of the cells as the filename.

Essentially, I don't want to create and fill in 250 virtually identical files if i can do this with a macro or something.

Let me know what details I left out and thanks for your help!

Clay

no one?