I am looking for a simple way to add data from multiple sheets without having to individually select each sheet, select the cell, and move to the next sheet, adding them on my "master" sheet using a "+" formula.

i have a checklist. my supervisors mark off yes or no for safety compliance on a given date. i want to compile all the data for a week under a single cell while maintaining the individual supervisor's data. i have a sheet for each supervisor. Cell C2 is titled date, D2 is Yes and E2 is No. My data starts at cells C3 which has the actual date of the observation, for instance 8/20/11. Cells D3 and E3 would then have either a 1 or 0 depending on the findings. this is uniform through all sheets.

i want to add all the D3 cells within a date range on a separate sheet where i can graph a week or month or quarter of results. Using "<date>date" i know i can specify a given range, but i dont know how to do that for multiple sheets. i suppose i could use access in some way, though i am not familiar with it and would like to keep everything in excel.

any suggestions are greatly appreciated