Is there a way to modify the code so:

1. It only looks at one sheet to print the list? (now it seems to
require the same list on two sheets - 1 & 2)

2. So it closes a gap if there is a gap in the list? (now it repeats
the entry before a gap)

Thanks!