Automate invoice

I need to automate invoice creation. The sample has only 2 quotations, FN-1562-RH1-01439 and FN-1328-BE1-205435. However the actual data has hundreds of them.
The 1st one, FN-1562-RH1-01439 has 2 Service Orders. Customer got 2 services for the same items. The service was completed after 2 visits. The same quotation FN-1562-RH1-01439 must show the 2 Service Numbers 721282 and 723289. The next quotation has one Service Number.

In the attached file, there is an invoice that shows in red font what I need to show.

Is there a maximum number of services a client will take? Could you modify your invoice to have service1, service 2, service 3 (blank if not taken)?

Also are you looking to create a block of invoices, or just as and when you add data to Sheet 1?

If you dont need to create a block then vlookups might work better than direct cell links.

There is no maximum number of services per quotation. I need to automate for a block of invoices.