how to display several items in one form with reference coming from other sheet?

[Len Cun]

hi Admin!

please help me..

how to create a form that will show a summarized data coming from another sheet. id like to know how to create a fillable form wherein when you enter a certain text(case No.), it will display all related details. example:

sheet1(contains all data)
sheet2("supposed form" where i will enter the text)

sheet 2 would look like this:
[TABLE="class: outer_border, width: 300, align: left"]
<tbody>[TR]
[TD]Case No.[/TD]
[TD]9-12345[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Franchise Route:[/TD]
[TD]Manila-Pampanga[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Expiry CPC:[/TD]
[TD]Sep 30 2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EOV Date:[/TD]
[TD]Aug 03 2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bus No[/TD]
[TD]Engine No[/TD]
[TD]Chassis No[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]abc-123456[/TD]
[TD]cde-987654[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]efd-657890[/TD]
[TD]tre-098765[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]pto-098123[/TD]
[TD]rto-098345[/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="width: 421"]
<colgroup><col><col span="3"><col><col span="2"></colgroup><tbody></tbody>[/TABLE]















When I entry the case no. all the details will be shown.
I tried the vlookup formula, but i cant find the right formula wherein it will automatically display all the bus No. w/corresponding details at once, when i enter the case number.

each case no.has several buses under the same case with different engine and chassis no.

please help.thanks in advance!

Len