what i need help with is a macro telling my user form what sheet to input the data on;
i am building a workbook for a fleet dispatch log
all the sheets are the same the only thing different are the sheet names van1,van2, van3, and so on

I need my first listbox (vehicle) to set the placement of the data onto the right sheet
The user form has an add button

any help would be great

Al