Excel vba code required to insert jpeg images into sheets and delete unused.

Dear all,
I have an excel workbook which had some 10 sheets (from sheet1 to sheet10)
I need to code to insert jpeg files into sheets.
Code must do following below,
-Must prompt user to select multiple jpeg files in one shot.
-If 4 jpeg are selected, it must insert images into first 4 sheet and delete last 6 sheets (unused ones)
(Similarly if 2 jpeg are selected, last 8 sheets must be deleted...so on...)

Plz provide me the code.
Thanks for your support.

Thanks for this response! !