How to copy or move all worksheets to a new workbook at a single click

Very nice

Many thanks!!! Worked exactly how you demonstrated. And thanks for being so clear and direct to the point!

hi thank you so much for your help! that is veryyy helpful, it saved me soo much time rather than manually selecting one sheet each - Nadia St Gregory Spa

what if we want the sheets to be copied at the end of every existing sheets?

Lgreat!!

THANK YOU!!!! This worked perfectly!