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]

JOB NO:	WHARFAGE :	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0506	BALLEYA ENT			-	6,694,028		6,694,028

<colgroup><col><col><col span="6"><col></colgroup><tbody>
</tbody>

 

[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