Excel Consolidate timesheet Data into 1 spreadsheet

We have 26 x MS Excel 2007 timesheets. Each timesheets is for one project, so we have 26 projects / timesheets to process. Each project timesheet has up to 12 employes working on it. The data for each employee goes back approx 1 year. Their time sheet consists of the employee initials, date, start time, finish time, phase & task. The individual employee data from those 26 timesheets need to be copied and pasted into a new single timesheet as a long columns of data. The process is to have the new Excel master timesheet open, then open the old timesheet and copy and paste a block of employee time sheet data into the new master timesheet. Add the name of the project code and the employee initials to the new data using drag and fill. Attached is a copy of the NEW MASTER timesheet file already set up. You can see an example how the data is to look. Attached is a copy of an old project timesheet data file which shows the data to be copied. You can see an where the data is to be copied from. Note each employees timesheet is a seperate worktab and each weeks' data is a new block across the top of the worksheet. The job is very simple, just a bit repetitious. Good luck in your bid!