I have two excel files, one is a data excel file and the other is what i want
to merge the data file into. I want to be able to merge like I do for word
document where there is a mail merge and it creates a separate page for each
merge that it completes. Is this possible?

e.g.

<<First Name>> <<Last Name>>
<<Address1>>
<<Address2>>
<<City>>, <<State>> <<Zip>>


If I want to be able to merge an excel sheet that contains this data into a
different excel sheet that looks for each value AND continues to merge the
rest of the document how would I go about doing that?