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.