Filtering Multiple sheets of data Question

Simply put... how can I do it? Any help would be appreciated ... I'm stuck.

I'm trying to filter data by month and by employee shift. I have 12 worksheets to reflect each months worth of data. Month being a column, shift being a column, etc. I have quarterly report sheets as well, but I'm trying to figure a way (or formula) in which I can filter for instance all employees that worked 3pm, during those quarterly period months, etc. I know how to do it per each worksheet, but I'm interested in learning if I can do this on say a quarterly report, where I dealing with multiple worksheets. I might have one employee (we'll call him Tom) work 3pm shift one month and the next month he'll work 11pm, etc. The workbook i'm creating we'll pull averages of employees working a specific shift period and this is why I need to filter data from multiple worksheets. I asked something similar to this previously and although I received a reply I didn't understand how to do it...I'm using office 2007, which I'm hoping will also have some options to help in this matter. I'd sure appreciate any and/all advice. Thanks in advance!!