Hi. I hope that someone can help me.

I have a form that has been set up previously in Excel
for stock counts. The form is complete with headings and
boxes at the bottom of the form to be signed once
printed. There is an are of 18 rows that I am interested
in as I want to extract data from another spreadsheet and
populate the form. That sounds easy but I also want the
form to print like criteria. Eg if there is one record
with a location of "A", I want it to print a unique
sheet. As soon as the location changes, I want to print
a new set of sheets. If there are more than 18 rows of
data within the criteria, I want to print sheets until
all items are included.

How do I do this in Excel?