Data count with two worksheets

[Guest]

I am looking for a formula that would gather a range of data from mulitple
tabs and put the value of one column in a "summary" tab. Example: I have 5
tabs for each staff. Column 1 has the dates for 2006, column 2 has revenue
for that day. I would like my "Summary" worksheet to pull up the yesterday's
revenue for each staff - summarized. Is this possible? Any suggestions?
Thank you.

 

[Guest]

Hi CallCtrHelp
Try this.
In the summary worksheet: Name the Tab "Summary"

1 In cell A1 type "Yesterday's Date"
2 In Cell B1 type =today()-1
3 Apply the required date format to cell B1
4 In cell A3 type "Employee Name"
5 In cell B3 type "Revenue"
6 In cells A4:A8 type the employees Name
7 In cells B4:B8 type =SUMIF(Employee1!A:A,"="&Summary!$B$1,Employee1!B:B)
8 Ammend Employee1! to the name on the tab for each employee

Regards
Phil Smith