Hi,
No need to be sorry. I'm getting closer to what you want.
You want the info in the data worksheet to populate sheet 1 of the Form sheet and Sheet2.
Now the new question is for example you have a vendor named "A&B Construction".
It is listed several times. I can see that you will populate the form for the first record.
Now you want to enter the next record for the same customer. How do you want to enter the second record? If you enter the next record it will over write the data in sheet1! Sheet2 would have no problems. It will go to the next row.