Finding the adjacent cell value by referring the cell value and paste the content to next sheet.

[mayaa_mmm]

I have an order number such as 012, 013 in a separate sheet with details like

[TABLE="width: 295"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Order No[/TD]
[TD]012[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Status[/TD]
[TD]UserName[/TD]
[TD]Action[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Tom[/TD]
[TD]Await Approval[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Richard[/TD]
[TD]Await Approval[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Swetha[/TD]
[TD]Await Approval[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Michael[/TD]
[TD]Rejected[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Marimuthu[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Approved[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 295"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Order No[/TD]
[TD]013[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Status[/TD]
[TD]UserName[/TD]
[TD]Action[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Tom[/TD]
[TD]Rejected[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Richard[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Swetha[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Michael[/TD]
[TD]Await Approval[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Await Approval[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Marimuthu[/TD]
[TD]Await Approval[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table, width: 497"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I want the summary sheet/Report by providing the await approval (action column) and adjacent cell value (Username). Similarly i have an orders in the separate sheets.
Report should be like

[TABLE="width: 558"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Order No[/TD]
[TD]Action [/TD]
[TD]User name 1[/TD]
[TD]User name 2[/TD]
[TD]User name 3[/TD]
[/TR]
[TR]
[TD]012[/TD]
[TD]Await Approval[/TD]
[TD]Tom[/TD]
[TD]Richard[/TD]
[TD]Swetha[/TD]
[/TR]
[TR]
[TD]013[/TD]
[TD]Await Approval[/TD]
[TD]Marimuthu[/TD]
[TD]Gopi[/TD]
[TD]Michael[/TD]
[/TR]
</tbody>[/TABLE]


[/TD]
[/TR]
</tbody>[/TABLE]