macro code for printing pages through the dropdown list in a cell

I have a excel sheet. In which in a cell I have a drop down list of numbers from 1 to 100.
when selected 1 from drop down list it looksup data in other excel sheet in same workbook.
I want to print this page and so on through the list ends in 100.
pls provide a macro code for this to print the list selecting from 1 to 100 in a single command.

Thanx dave for this useful info.
but I am new to macros and dont know how to edit the code.And i have attach the file in which drop down list have only 1 to 5 enteries. Then pls tell me the code according to it and also set the print area of page A4 or page 1 only .
Once again thanking you.
neeraj arora