Auto populate Cells from lookup Worksheet

[Andrew5150]

Sorry if this has been asked before

I've a worksheet (Sheet 2)which contains the following information, but some 900 lines long. This Worksheet can change, which is why I looking for a formulated fix.
[TABLE="width: 500"]
[TR]
[TD]
[TABLE="class: grid, width: 500"]
[TR]
[TD]Code
[/TD]
[TD]Company
[/TD]
[TD]POC
[/TD]
[TD]Alt POC
[/TD]
[TD]Manager
[/TD]
[/TR]
[TR]
[TD]ABC123
[/TD]
[TD]Pinewood Studios
[/TD]
[TD]Fred Bloggs
[/TD]
[TD]John Smith
[/TD]
[TD]Simon Daily
[/TD]
[/TR]
[TR]
[TD]DEF456
[/TD]
[TD]Paramount Pictures
[/TD]
[TD]Bert York
[/TD]
[TD]M Streep
[/TD]
[TD]James Weekly
[/TD]
[/TR]
[TR]
[TD]GHI789
[/TD]
[TD]Sony Pictures
[/TD]
[TD]Susie Que
[/TD]
[TD]H Spielberg
[/TD]
[TD]Jane Doe
[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]

On the main worksheet there are far more columns, which I would like to Just input the code from the worksheet 'Sheet 2' above and
in the Code column and have all the other respective columns auto populate. The issue is that the Column configuration is not the same.

[TABLE="class: grid, width: 900"]
[TR]
[TD]Date
[/TD]
[TD]Code
[/TD]
[TD]Company
[/TD]
[TD]Project Name
[/TD]
[TD]Manager
[/TD]
[TD]Location
[/TD]
[TD]POC
[/TD]
[TD]Budget
[/TD]
[TD]Genre
[/TD]
[TD]Alt POC
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DEF456
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]GEF789
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ABC123
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]