Excel doesn't do "Mail Merge", it's Word doing all the data pulling. You
will need to replicate that functionality yourself with Macro/VBA or
formulas.

jeanne wrote:

I want to create a merge whereby the data from one spreadsheet is distributed
to multiple sheets. The same thing as a mail merge from excel to Word, only
Excel to Excel.