Hi Miss S.

Within VBA you can reference a worksheet in a number of ways. You can use
the number of the sheet within the workbook, ex. 'Sheets(1)....', or you can
use the name of the worksheet on it's tab, ex. 'Sheets("Sheet 1")...', or you
can use the name of the worksheet as it appears in the Project Explorer in
the VBA Editor, ex. 'Sheet1....'

So, you could put a list box on your form and then use their selection to
reference the appropriate sheet. You could either use either the list index
with method one above, or the selected value (assuming it matches the
worksheet tab exactly) with method two above. Alternatively, you could also
use radio buttons and a select case statement with method three above.
Personally, I think it would be best to use one of the first two methods.

If you'd like to discuss this further, please feel free to e-mail me,
HTH,
tdw