matching name and running formula

[tarus]

Hi everyone, I've got a simple spreadsheet with
column A employee name
column B start of absence
column C end of absence
column D total numbers of days off

I'm running three formulas to work out number of absence days in past 3 months, 12 months and the total number of days in twelve months which work fine but ..., I'd like to be able to add this info for an employee into a return to work letter on another sheet. So if I typed their name into the letter on sheet 2 for example it would give me the absence information on this sheet in 3 cells. I can't work out how to only run the formulas against the matching employee name (should I look at it another way?)

Any help would be greatly received,

Thanks

 

[tarus]

Hi, thought I'd add a little more info. These are the formulas that I'm using
12 MONTHS =SUMPRODUCT(--(Sheet1!B:B>=DATE(Sheet1!H22+Sheet1!E2YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))),--(Sheet1!B:B<=TODAY()))
3 Months =SUMPRODUCT(--(B2:B1005>=DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY()))),--(B2:B1005<=TODAY()))
No. of days in 12 Months =SUMIF(B1:B1999,">="&TODAY()-365,D1:D1999)
Can I get these just to run just on one given employee name from Column A when there are many enteries?

Thanks again.