i have an application that tracks 18 workbooks (one for each person) right
now. each workbook has 12 sheets, 1 for each month and a line for each day
of the month. i now summarize some of the data monthly, on each monthly
sheet and report it in a separate workbook

now, the client is asking for some daily summaries in another separate
workbook. specifically i need 3 items, (1) transactions and (2)hours by
(3)branch for each day. like i mentioned, there are 18 workbooks right now.

so i am looking for the best way to do this.

for example:

august 29th would have between 10 and 18 possibilities, but i still need to
check each person's workbook, even if they don't happen to work this day.
then i need to look at the branch code that's entered for this day, and add
the total hours for each of 5 branches and total transactions for each of 5
branches for this day.

then i need it for every day of the month and ultimately the year.

how would you handled this? long formulas?
--


Gary