Extract Data /Look up Data / To get data automatically by refering invoice number

Dear All,

I would like ask for help for the following formulas. I have tried to create by learning , however, I couldn't get the solution.

Could someone help me please if these will possible to create it ?

I would like get automatic data ( look up data ) by referring invoice number .
Attached is sample file .

1) Inv Details Sheet

2) Inv Summary Sheet : Wanted to get combine data of multiple item names from "invoice Details sheet" to "Invoice summary Description"
3) Inv Format Sheet : Wanted to get automatically "Batch Number" and" Expiry Date " data under item name of the invoice by looking up invoice number.

Kindly guide me , please. Thanks in advance for your valuable time .