Hi,

I'm a quite amatuer in Excel so I need a help in the following:
I developed a spreadsheet with several worksheets named each by months of
year. Each monthly sheet contains datas in same structures - they are daily
production figures, losses etc.
Now I want to make a separate worksheet which extracts these datas from any
of the monthly sheets for a determined date - making a Daily Production
Report.
I guess the right function will be the VLOOKUP - I have no problem with
using this function. But how can I define that it searches in the right
monthly sheet?
Secondly how can be this DailyProductionReport worksheet (only this) be sent
to pre-defined mail-recipients?

Any help would be much appreciated.

FicsiPapa