transfer data Between excel sheets

[kvirmani]

I have a few excel sheets that have the hours worked by different people on different jobs and the dates that people worked on the job.
I want to make another sheet that is specific to the job. I Want the job and the no of hours spent by each person on that job.

I want this so that from the time sheets of different people. I can figure out who all worked on a job and how much time they spent on it and on what date.

Can anyone help me ?

[Logistical]

What I want you to do here is that use the dynamic range and then paste the data of the classes that you want and at the top into a master sheet and later on don’t forget to pivot the same. For more information I want you to click on the link mentioned here: Transfer data between sheets in excel