Using a User Form to pull data from multiple sheets into main sheet

Okay bear with me, this might be a confusing/long question but I would SUPER appreciate any help...

I have an excel workbook that contains multiple sheets of data, one for each Product (Product A, B, C, D...) in which each sheet has a table of information, and a Main sheet that I would like to display different information in.

In each sheet, the table of data includes Column A (Item#), Column B (Quantity), Column C (Quantity * 1), Column D (Quantity * 2),
and Column E (Quantity * 3)

I have created a User Form in the Main sheet that allows user to select which Product (Product A, B, C, D...) and what number of Lots to produce (1, 2, 3) they would like to see data for using drop down boxes.

SO, I would like to create a macro that, when a user chooses the Product and #, will pull all the correct data from the corresponding tabs and populate it in a blank table located in the Main sheet

I am not super well versed in VBA so in trying to figure out this code, I started to just write out the logic from my head in a way that hopefully other people understand what I'm trying to accomplish and be able to help with... here goes nothing:

Private Sub CreateBOM_Click()

Dim lngRow As Long
Worksheets("Master BOM").Activate
lngRow = Worksheets("Master BOM").Range("B1048576").End(xlUp).Row + 1

'Based off what options you chose, excel will grab the correct data from the corresponding product tabs

If ProductName = "A" & NumberLots = 1 Then
    Cells(lngRow, 1) = Worksheets("A").Table("ProductA").Column("A")
    Cells(lngRow, 2) = Worksheets("A").Table("ProductA").Column("B")
    Cells(lngRow, 3) = Worksheets("A").Table("ProductA").Column("C")   'C would be quantity * 1
    
If ProductName = "A" & NumberLots = 2 Then
    Cells(lngRow, 1) = Worksheets("A").Table("ProductA").Column("A")
    Cells(lngRow, 2) = Worksheets("A").Table("ProductA").Column("B")
    Cells(lngRow, 3) = Worksheets("A").Table("ProductA").Column("D")   'D would be quantity * 2
    
If ProductName = "A" & NumberLots = 3 Then
    Cells(lngRow, 1) = Worksheets("A").Table("ProductA").Column("A")
    Cells(lngRow, 2) = Worksheets("A").Table("ProductA").Column("B")
    Cells(lngRow, 3) = Worksheets("A").Table("ProductA").Column("E")  'E would be quantity * 3
 
If ProductName = "B" & NumberLots = 1 Then
    Cells(lngRow, 1) = Worksheets("A").Table("ProductB").Column("A")
    Cells(lngRow, 2) = Worksheets("A").Table("ProductB").Column("B")
    Cells(lngRow, 3) = Worksheets("A").Table("ProductB").Column("C")   'C would be quantity * 1
    
If ProductName = "B" & NumberLots = 2 Then
    Cells(lngRow, 1) = Worksheets("A").Table("ProductB").Column("A")
    Cells(lngRow, 2) = Worksheets("A").Table("ProductB").Column("B")
    Cells(lngRow, 3) = Worksheets("A").Table("ProductB").Column("D")   'D would be quantity * 2
    
If ProductName = "B" & NumberLots = 3 Then
    Cells(lngRow, 1) = Worksheets("A").Table("ProductB").Column("A")
    Cells(lngRow, 2) = Worksheets("A").Table("ProductB").Column("B")
    Cells(lngRow, 3) = Worksheets("A").Table("ProductB").Column("E")  'E would be quantity * 3

'...etc 

End If

I know there MUST be an easier/more efficient way of writing this, so if you have any ideas or need more context please please let me know!

Thank you so much!