Is it possible to use multiple tabs in a workbook as one data sour

[Michelle @ BMA]

I want to create a merge, but the data is within 5 different tabs of my Excel
document. If you can't choose more than one worksheet, then what is the best
way to pull my data from the spreadsheet???

I can't believe there's no way to do this. I tried to learn pivotreport,
but it's not the type of report I need.

I have a spreadsheet containing multiple worksheets. Each worksheet contains
different info. for the same 73 centers. I now need to print out the data
for each center individually & would like to condense the info. to a minimal
amount of pages (3-4).

 

[Doug Robbins - Word MVP]

Mail merge can only use a single flat file as a data source. As a result,
you would need to link the required information from each of the sheets onto
a single sheet.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP