Spreadsheet Layout from Data Dump

The story:
I am a project scheduler currently working on a program of several projects all with the same activities, but different dates. I have a project manager who likes to see the information in a different format than what Primavera has to offer and am using excel to attempt at automating the process...

The problem:
After hours of looking through forums, I decided my problem must be somewhat unique, and I have tried various attempts at combinations of IF, INDEX, MATCH, and VLOOKUP formulas but have been unsuccessful...the easiest explanation is the attached example.

The solution:
I need to be able to bring in the Raw Data (as it appears in the attachment) and have the Desired Format cells automatically run a criteria check for the Appropriate Site, then the Appropriate Area, then the Appropriate Activity Description (which is repeated again and again for every project) and put in the Appropriate Start Date or Finish Date (depending on which column the formula lies in).

Feel free to ask me any questions and I will try to clarify. Thanks to anyone who can help...

Regards,
-Trent