Create a Master Sheet from several individual sheets

Hi. I'm new here, but I have a question that seems to me like it should have a simple answer.

I have several sheets in the same book. They are all timesheets, one for each employee. I'd like to create a master sheet that will pull all the raw data from each employee's timesheet. Each employee works on numerous jobs (listed by job number), and they vary from week to week, so there's no consistency. I may have more than one employee working on the same job. I do need all the raw data on the master sheet, but I still want to have individual timesheets, so just putting all the data into one sheet in the first place doesn't do me any good.

Is there any way to do this?
Thanks in advance.

It would help if you posted an example workbook (the FAQ describes how to) so we can see how your data is laid out. How many employees (i.e. sheets) are you likely to have?

Pete

I am likely to have 4 or 5 timesheets for now.
Employee Time Sheet Template.xls
I hope I did that right. That is the sample timesheet we're working with now.

Ah. I'm a little loathe to put an actual time sheet up, because it references properties we work on, as you can see from the coding for Column B.
Regardless, I'd just like the information in the individual timesheets to all show up in one worksheet. Same data, not pulling individual bits. That way each employee's time is separate for other purposes, and for billing purposes, we have all the information in one place without having to reenter everything.