extract data from sheet 1 to sheet 2

[makinmomb]

I have a sheet columns a to i

I need a macro to that will read sheet 2 cell a1 in which i will plug truck number example TR-0506 , The macro then needs to go to sheet 1 search cell a1 where it finds the truck and then pull all those rows a to i starting row a3 as a2 will have headers

I need a summary kind of details of that truck so that i dont have to use CTRL F and waste time

 

[makinmomb]

[TABLE="width: 1305"]
<colgroup><col><col><col span="6"><col></colgroup><tbody>[TR]
[TD]JOB NO: [/TD]
[TD]WHARFAGE : [/TD]
[TD]USD [/TD]
[TD]APPROVED[/TD]
[TD]DIFF[/TD]
[TD]TSHS [/TD]
[TD]APPROVED[/TD]
[TD]DIFF[/TD]
[TD]REMARKS [/TD]
[/TR]
[TR]
[TD]TR-0506[/TD]
[TD]BALLEYA ENT [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] 6,694,028[/TD]
[TD] [/TD]
[TD] 6,694,028[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

The macro should ignore any merged cells as one header in the data is the day e.g 01/08/2018
where the data of that day begins and then followed by 02/08/2018 merged cell where again the
data of that begins

 

[makinmomb]

Still struggling with manually doing it the long way