Selecting A Worksheet Through A Macro

I've recorded a macro to insert new rows and have text put into them, or pasted from a source sheet, wha i now want to do is have the macro aske which sheet to work on so i can do the same thing on multiple sheets. anyone know of a way to do this?