Summary Worksheet totals
 

Each one of my worksheets contain payment records for only one person. They
are set up:
A FName
B LName
C DatePaid
D AmtPaid

The tab names on each worksheet are the person's name (ie Bill, Sally, Jim,
etc).

I want to use a summary workwheet to list and total all payments made
between two dates for a deposit record.

I would like to use a date picker to pick a start date and end date. Then
have the following infromation from each worksheet listed on the summary
worksheet ONLY IF payments were made during the time picked. Somewhere on
the summary worksheet I would like to include the Start Date and End Date.

A Fname
B Lname
C AmtPaid

How do I do this?


Thanks
Hank