importing data by assigned ID
 

I have an excelworkbook with data-output.
1st row are headers
1st collomn assign id

I need to import the data from 1 workbook into another workbook per assigned
ID (preferably the data from each ID directly into predetermend cells in the
new workbook).
ID's are numbers: 1 to 50.
however, one ID number can be on several rows with different data in the
collomns behind it.
eg: 1
2
2
2
3
4

And not every collumn holds data for every ID and no empty cells should be
imported yet headers of colloms holding data should.
e.g. collomn 1 through 8 and collomn 34 through 47 hold data for ID 1-
4through 7 and 22.

Can anybody tell me how to do this..?