Forgive me, I don't know much Excel lingo. I'm changing the layout of
packing slips for a fundraiser company.

The Tally Sheet read:
Column A Column B Column C
Cookies Cakes
Row1: Joey 5 2
Row2: Billy 3 1

The packing slips read:
Row1: Name - Joey
Row2: Cookies 5
Row3: Cakes 2
Row4: _________________________
Row5: Name - Billy
Row6: Cookies 3
Row7: Cakes 1

The individual student's sales are on one worksheet, but when I'm pulling
them onto the packing slip, the cells are several rows apart, therefore the
cell number advances that many. Any way to do this besides entering it on
all 250-500 packing slips by hand? Thanks!