How to List - Automatically

[Nivlem]

If sheet A consist of a list like this:
<table height="138" width="423" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:3328;width:68pt" width="91"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> </colgroup><tbody><tr style="mso-height-source:userset;height:33.95pt" height="45"> <td class="xl8378" style="height:33.95pt;width:62pt" height="45" width="82">ORACLE ID</td> <td class="xl8378" style="border-left:none;width:68pt" width="91">PO NUMBER</td> <td class="xl8394" style="border-left:none;width:88pt" width="117"> AMOUNT </td> </tr> <tr style="mso-height-source:userset;height:15.75pt" height="21"> <td class="xl8379" style="height:15.75pt" height="21">119088</td> <td class="xl8380" style="width:68pt" width="91">9300437306</td> <td class="xl8383"> $ 467.00 </td> </tr> <tr style="mso-height-source:userset;height:15.75pt" height="21"> <td class="xl8379" style="height:15.75pt" height="21">119088</td> <td class="xl8380" style="width:68pt" width="91">9300437305</td> <td class="xl8383"> $ 467.00 </td> </tr> <tr style="mso-height-source:userset;height:15.75pt" height="21"> <td class="xl8379" style="height:15.75pt" height="21">119088</td> <td class="xl8380" style="width:68pt" width="91">9300437304</td> <td class="xl8383"> $ 467.00 </td> </tr> <tr style="mso-height-source:userset;height:15.75pt" height="21"> <td class="xl8379" style="height:15.75pt" height="21">119088</td> <td class="xl8380" style="width:68pt" width="91">9300437281</td> <td class="xl8383"> $ 467.00 </td> </tr> <tr style="mso-height-source:userset;height:15.75pt" height="21"> <td class="xl8379" style="height:15.75pt" height="21">119088</td> <td class="xl8380" style="width:68pt" width="91">9300465162</td> <td class="xl8383"> $ 467.00 </td> </tr> </tbody></table>

I want to show this exact list on Sheet B if I enter the just the ORACLE ID once.
Is this possible without turning Sheet A into a Pivot Table?
My humbles gratitude.

 

[XLSM]

Your example shows 5 PO Numbers for the given Oracle ID. Can this number vary? What is the maximum number of PO Numbers associated with each Oracle ID?

Also, when you say exact list, do you also mean that you want the information in the same 3 column format or would it be fine if the result had the PO numbers listed in columns - like PO Number1, PO Number2, etc.?

 

[Nivlem]

The Amount of PO will vary from one to xxxx. It would be ideal to have the PO under one column only and the amount be in another.