MS Excel Consolidate spreadsheets

We have 38 x MS Excel 2007 worksheets. Each worksheet is the data of a ontents of a container of goods. Each worksheet has approx 10-100 lines of [login to view URL] process is to have a new Excel master spreadsheet open, then open the old worksheet tab and copy and paste a block of data into the new master shreadsheet. Add the name of the project code and the container number to the new data using drag and fill. Attached is a copy of the NEW MASTER spreadsheet file already set up. You can see an example how the data is to look. Attached is a copy of 1 of the tabs from the old data spreadsheet file which shows the data to be copied. You can see an where the data is to be copied from. Note each container is a seperate worktab. The job is very simple, just a bit repetitious. Good luck in your bid!