Im trying to create a macro that will add number of new sheets depends the
number of items on the list of column D. name it C1, C2, C3, C4, C5...

AutoFilter the list, choose the first item, copy the content of active
sheet and then paste on the C1. Continue AutoFilter, choose the second item,
copy the content of active sheet and then paste on the C2. Do the same for
the rest of items on the list.

I have had a macro that add sheets, name the sheets, copy the contents of
sheet to the new sheet after AutoFilter the list. The list is limited to 4
specific items. But sometimes the list changed, it has more than 5 or 6
different items.

Any suggestion?

Thanks
--
Aline