Disclaimer - Newer to VBA.

I have a sheet I want to print out, for each record in a range.

In the range, I have the following data:

Apple
Grape
Pear
Apricot

The price breaks are based on information in columns 2 - 4 of the range.

I have a seperate window, which is all formated pretty like. What I want to do is enter Apple in the top cell (programatically) and print the page, then change Apple to Grape, and print the page again.

I am trying to do something like a For each, Do Loop....but am not having any luck....any ideas ?