Can I use a Hyperlink to send a Workshheet from a selected workbook to a selected E Mail A

All Hi,

Is it possible to use a Hyperlink to do the following:

From a selected workbook - May have 150 separate worksheets, want to be able to select an individual worksheet and from information in cell D25 ( This cell in each sheet holds the E mail address) then E mail the worksheet to the E Mail Address.

If it is possible can someone provide me with the answer


Thanks