I have a workbook with a number of sheets containing individuals results.

Each sheet is named after the person, e.g. Fred, Janet, John, Susan.

I'd like to be able to press a button on each sheet and for that individual
sheet to be mailed to the person based on their e-mail address in cell Q1.

Over time sheets will be added/deleted as people move on/join.

Is there an easy way to set this up as the person using it has very limited
Excel skills?

Thanks in anticipation