I have about 10 different workbooks, each with about 20 worksheets. Each workbook will be sent to different groups of about 4 people. Follow me so far??

Out of these groups of 4 people, each person will use only 5 of the sheets. Rather than determine which 5 sheets are important to each user and make 40 user-specific workbooks, I would like to make 10 generic workbooks and allow the user to select the sheets that are important.


EXAMPLE

I am one of the 4 people in a group that receives a workbook. I open my workbook and see that it contains 20 sheets. Shoot! That is a waste of time because I only need sheets 1 to 5 (always).

NEEDED SOLUTION

Because the users are not usually very computer literate, I would like to setup a control button that, when clicked, displays a listing of all 20 sheets. From that list, the user selects the important 4, 5, 6 etc. sheets and the rest are permanently deleted.


Please, please help me!!