conditional copy data from workbook to another workbook
 

I have book1 with 12 sheets and book2 with 1 sheet
on each sheet in book1 i have a combo box which i use to select that sheet
as the one i would like to copy from

I would like to use a combo box to select which sheet to copy data from in
book1 to sheet1 in book2.

I am trying to use a select case statement in the combobox.chnage() sub, but
i have come to a stand-still trying to figure out how to get the file and
sheet reference right in VB.