I need to extract data from up to 50 different worksheets in the same
workbook to merge to a standard word document. When I set up the data source,
it always defaults to the first sheet in the workbook. How do I get it to
look at the current or open sheet that I want to extract the data from ?
Many Thanks