I have an excelworkbook with data-output.
1st row are headers
1st collumn holds a previously 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
collumns behind it.
eg: 1
2
2
2
3
4

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..?

And is it possible to automate this with a macro and if so how..?

any help would be much appreciated.