Input data from UserForm to right place (Easy for those Knowledgeable)

Hey everyone,

[view Sample spreadsheet]
View attachment Book2.xlsm

OVERVIEW

I have a spreadsheet that tracks details on Meetings (Date, Time, Attendance, Meeting Overview). On the top there is some counter, it works let's ignore that, the focus is on the UserForm. The user of the spreadsheet will click the user form, input the data, and click submit

THE GOAL

I am trying to get the data from the UserForm to place itself in the proper place based on the supplier selected, perhaps with a simple VLOOKUP. This is probably really easy but I do not know how.

I am really struggling here, anything would help me even if it's a simple suggestion.

Thanks guys

Why the change in layout when SamT's suggested solution works for the previous layout ?

Please read this forum's stance on cross-posting, and then provide links: https://www.excelguru.ca/content.php?184