Start with the simplest possible solution, based on my reading.

Keep it simple. Keep it all in one file if possible.

Have you considered leaving the data in place and producing your
desired results on the RawData sheet through an autofilter?


Add columns for vlookups in the RawData table:

http://contextures.com/xlFunctions02.html

e.g. In the first row enter formulae and then copy down:
=vlookup(ProjectID,OverviewTable,NoOfColumns,0)
Replace "ProjectID" & "OverviewTable" with references fo the
relevant cell in the RawData table & the Overview table range
respectively.
Replace "NoOfColumns" with a number (representing the desired number
of columns in the overview table to the right of the projectID +1)


In your data area, select Data-Filter-Autofilter
From the drop-down boxes make your selections

Once working, can then look at improvements (error conditions, etc) &
consider alternative formulae if speed is an issue.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533348