Making a Master Consolidation Worksheet

[shahid5788]

Hi,

I was wondering if there a way to make a master consolidation master sheet in excel. I currently with large volume of worksheets. And then I have to manually copy paste the workbooks one by one. I currently receive about 80 excel worksheets and than manually have to consolidate them. I am hoping to find a better and effective way in order to consolidate these.

In these worksheet are are set of projects and the team records on of how many hours they worked on a corresponding project based on the day of the month.


I need to extract the total hours of each project and also the total of employee hours worked on that particular month.

As you can see example of worksheet below. I get about 80 other worksheets in which I have to manually extract the data of each employee and the project total and monthly totals. I am trying to find a more efficient other than just v-lookups. Hoping to find a way in which there is a way to consolidate where it would spit out the data I need (I.E ex "Employee Name" "Project A Total" "Monthly Hr Totals"

James		Jan						Jan							Jan							Jan
		Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr
Project Code	Project Title	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27
																													0.0
IN	A																												0.0
IN	B																												0.0
IN	C																												0.0
IN	D			6.0	6.0	6.0	6.0			6.0	6.0	6.0	6.0	6.0				6.0	6.0	6.0	6.0			6.0	6.0	6.0	6.0	6.0	108.0
IN	E																												0.0
IN	F																												0.0
	Daily Totals	0.0	0.0	6.0	6.0	6.0	6.0	0.0	0.0	6.0	6.0	6.0	6.0	6.0	0.0	0.0	0.0	6.0	6.0	6.0	6.0	0.0	0.0	6.0	6.0	6.0	6.0	6.0	108.0

<colgroup><col><col><col><col span="26"><col></colgroup><tbody>
</tbody>