I have a worksheet called Listing. There will be more/less WS as people
move around, but lets call these sheets Tom, Bob, and Jim.

WS Listing has 12 columns with headers. Not all the cells are filled in all
the columns. The headers start in 3A and the data starts in 4A. All of it
is in a list.

The WS Tom, Bob, and Jim are all the same format so I will describe only WS
Tom
WS Tom uses five columns starting in A8.

WS Tom has a command button which starts a macro to start a userform. The
user form is a multiselect Listbox. I need the userform to go to WS Listing
and pull columns A-E and H-I starting in row 4 and going until there are no
more entrees in row E or I (these columns will both always have an entree if
the row is used). Also it needs to clear itself everytime before it reloads
the list so that it will get the most current inventory.

The same userform has a command button. After the user selects all the
desired items they will click this to run another macro I would assume. I
would like it to copy the selcted items in columns A,B,E,H,I from WS Listing
and the WS title of the WS it is selected from (in this case Tom) to WS
Pending starting in A7 (the headers start in A6).

I have been trying with the help functions, but I have only been able to get
the command button to pull up the userform and put some of the information in
it. I am not good at this by any means so please speak slowly. Thank you in
advance for any help.

Regards,
AUCP03