how to list multiple invoices against single PO both being seperate sheets in the same workbook

Dear Friends,

i have a work book in which there are many worksheets.  one of them is named PO and another is invoice.

in the PO worksheet there is a list of PO s received along with other details.

in the Invoice Worksheet, there is a list of all bills raised against these POs.

in a seperate worksheet named consolidated, i want a list of all invoices with corresponding POs against which they are raised.

importantly, a single PO can have multiple invoices, but not vice versa.

can anyone suggest how this can be done automatically using Excel formulae???

Regards,

K R Ramu