I want to place a button or some similar form control on my initial summary
worksheet that calls a macro to insert and populate a worksheet just prior to
another worksheet of the users choice in the workbook. My macro works fine
when I execute it while I have the successor worksheet selected.

Is there a macro form I can use that allows me to instruct the user to
select form a list of worksheets to input to the macro execution?

Alternatively, is there a VB function like InputBox that I can use to
present the user with instructions and a selection list of all the
worksheets, so he can specify where to place the new work sheet?

I appreciate your help, -John