hi all. I have a userform in which people can select trips/events from a multi select listbox. The list box's row source is a named range containing the name of all trips. each trip has its own tab. The tab names are an abbreviated version of the trip name. I need to have the details of the user placed onto the respective sheets matching the users selection. how do I match up the trip selected to the abbreviated sheet name and transfer the user details accordingly?