name an active worksheet

[djshides via OfficeKB.com]

I have a workbook with several worksheets. After entering data into selected
sheets it needs to feed into a letter built in one of the worksheets. A
userform on the letter sheet is used to pick which worksheet the data should
pull from. I have visual basic code written so it pulls from one of the
worksheets at a time, but I would like to write code so it goes to whatever
sheet was selected in the userform. I would REALLY appreciate someone's help
with this as I have been struggling with this for weeks now. Thank you!

 

[Tieske]

if the form returns a worksheet name then you could use the INDIRECT() and
ADDRESS() functions to return the data from that specific sheet.

If this doesn't help, please be more specific on how your solution is
supposed to work.

Tieske.