This is a little short on details.

What's in the list?
Create sheets in the same workbook?
Does the sheet with the list  always have the same name?
Which column/row is the list in?
Have you tried already and what results/errors have you gotten?
Do you have any code to post?
Etc....