Need different data each time from different sheet

So I'm making an invoice form in which i need to insert data from another excel, which is a list that includes names/e-mails/amount paid/etc.
Is there any way I can make this proccess more automatic since the number of data is very big.

The data in my list worksheet are presented along the row, is there any way i could type that if this invoice is invoice number 2, then, this box should take the data of D2 (from the list worksheet) , then that box C2 and if 3, then D3, C3 etc.??