Hi everyone!

Here is my current challenge:
I have one workbook that contains multiple worksheets, each with different formats, but the data is the same accross (different views).

I have 11 additional workbooks that are used to update the master workbook- specifically, the first worksheet (workbooks attached).

What i need to do is the following:
Each workbook represents the status of an individual project submitted by different individuals. I must take these workbooks one by one and extract the information field by field and update the master workbook with this information for each project. the information to be updated includes the data and the background color for each field. This process alone takes me about an entire day to complete. although the fields in the master workbook are laid out in a different format, they contain the same filed names as in the other 11 files. Only that each ROW in the master perstains to a specific file.

Example: one workbook for a project named, FX contains all of relevant info for that project. The master workbook will contain ONE ROW that has all of the information found in the FX file. So while I am reading the FX file VERTICALLY, the master file is read HORIZONTALLY. Hope this makes sense.

I want to have the user specify the files to open. once the files are opened, have the code read through each individual file, extract the relevant information, copy to the appropriate cells in the master file, spit out a "diff" file with what changes where made, close the file.
Do this for every file until all files are read.

The attached file contains the crappy code that i have come up with so far, but it is not working correctly and it is becoming difficult to complete.


Can anyone PLEASE help me complete this?

The Zip file attached contains a copy of each of the status reports received (not all), my version of the master file with the code (project Dashboard_r7) and a copy of the official template that ALL of the managers will be using and from which my code will be based from.
I just got this new job, and I may be risking to lose it if I don't have this done. I don't make much $, but i know that this is a lot of work and I would be willing to pay someone to help me get this completed no later than Sunday, December 10, 2006.

Thank you all!!