Hi Experts, need your help!!!

I have a workbook, with information of individual reps on each worksheet. i
need these worksheets to be emailed to respective reps.

we can use any of the following
1. email address stored in the cell A1 of each worksheet.
2. email addresses stored in one worksheet in the same workbook. OR
3. email addresses stored in seperate workbook, with both workshhets saved
in the same folder where name and email address of the reps are stored in
seperate workbook in the sequence of the worksheets.

please please help!!!
if my question is not clear please let me know and i will give further
explanation.

but i need this to be accomplished ASAP.

Please HELP.