summary sheet display

[brianbox]

Hi

I have an workbook - each employee has a worksheet. Each worksheet contains:

Sickness Reason / First Date / Last Date / Total

For each employee you simply fill in the row each time they are absent and the total number of days they were absent.

However I would like a summary worksheet which will detail the below, but based on a date (ie last week) as it would be sent to payroll:

Name / From / To / Total days

I guess the formulae would be where date = last week dates, show row from each worksheet.

This is where I am stuck - any tips on how to go about this?

thanks
Brian