Can I have a progressive number in the same cell when printing?
 

I would like to enter a quantity amount in a log sheet that would be linked
to a worksheet. The worksheet would have a cell that would have a
progressive serial number. So if I put in a quntity of 20 in the log sheet,
it would print out 20 copys of the worksheet with a serial number that would
increase by 1. (Example 1001,1002,1003,etc). Is this possible?