Does anyone know how to do this (code) using a input/combo box

The user need to either select and excel worksheet to update (list of
worksheets is a range on another excel worksheet) or all worksheets

From the input box, it would ask if to update all worksheets (yes no)
if no it would bring up the another input box with the range of sheets to
select

Thanks
--
Helping Is always a good thing