Have a user form with list boxes that the user selects three choices.
Using these three choices, I need to insert the data into a worksheet.
One is product number, the second is a location from about 13 choices
and the third is a date

rows contain product number in descending order far left, then the 13
locations.

Columns contain the date (for a year by week)

Basically what I am asking is that how do I capture the input and then
perform a three way lookup to add the data.

Know its not the ideal way of setting this up, but it is 'live' sheet
that needs updating until the required results appear.

Many Thanks