I have a list of 20 or so part numbers, each with 20 or 30 of each part
number. I want to display only a specific number of each of those part
number on a new worksheet.

for instance, I have 20 of one part number, but only want to move the four
(or some other number as defined by an external list) to a new worksheet.
Then I want to look at the next part number, which might have 30 pieces, but
I only want to move 6 (again, as defined on this external list).

Any creative ideas?