VBA to create multiple copies of a sheet, copies named based on list in other sheet

Hello Experts,

Below Code helps create replicas of "Base" sheet with the names specified in "List" sheet.. i got this code from Net..
https://superuser.com/questions/9958...d-on-list-in-o
This works fine.. But the problem is.. i have 3000 values in "List" Sheet & i want to make 6 workbooks having 500 Sheets with those list or 250 having 12 workbooks.. how do we achieve this.. please assist

Please Login or Register  to view this content.

Please do not wrap links to cross posts with tags. Just copy paste the link to the board.
Thanks

I have made the post changes.. thank you for highlighting